Search results for query: *

Sage 300 2012 Inventory Control , GL Integration set to Create GL Transactions during Day End and Create GL Transactions by Creating and Posting a new batch. Occasionally on day end the GL batch creates but does not post and has to be posted manually. I cannot seem to find any reason for this -...

Thanks ettienne, I did come right with this.

Thanks I will try this out as soon as I can.

Thanks ettienne, Dump is throwing - SELECT (ec=49153) in a message box. The dataset directory at that point has all the files up to SPAUD.REC (that is 0KB in size). After I press Ok on the message box it deletes all the dump files.

I just inherited a site - Sage 300 6.0A, Windows Server 2008, Pervasive 10.2 - when running a verify on one of the company databases I get: SPAUD: No entry for this table in X$FILE. SPCHG: No entry for this table in X$FILE. SPERR: No entry for this table in X$FILE. SPGLB: No entry for this...

I am running it directly on the server hosting the database but the recovery model is full. I will amend and give it a try. Thanks for your assistance.

Thanks, Sage 300 2012 (PU3) SQL Server 2012 Unfortunately it is a very low spec box in the interim: 64bit Windows 2008 R2, 8GB RAM, Intel Xeon E5620 2.4GHz.

I have an import procedure that inserts approximately 10000 purchase orders, receipts and invoices (approximately 30000 documents). How long should the Day End after this typically take? It currently is on about 8 hours. Do I have any options for speeding this up? Thanks in advance.

Sorry, that was meant to be Sage 300 6.1

Sage 300 7.1 with RMA. I have a serialized item that is set as automatically attached to a specific warranty code on registration. This item was sold, shipped and invoiced via OE. I then ran Day End in IC. The serial number was registered using IC Serial Registration and the number is now...

Thanks so much - that changes everything! I was assuming that the category was attached to the item and not editable.

Hi - as far as I can tell the only way once can override GL segments is via inventory control locations. Please consider my problem: Different sales channels (e.g. Call Centre and Direct Retail) selling the same product (under the same IC category) with the stock held at a single location. I...

Great, thanks. I was trying SetActiveWindow and BringWindowToTop but SetWindowPos does the trick.

Hi, I have a small macro and am struggling to get it to maintain focus over the Sage 300 (2012 6.1A) application. I am just using SetForegroundWindow attached to a timer on the actual form I want at the front. When running in the VBA editor it works ok and brings itself to the top of the...

Ok, thanks for your assistance.

Thanks, I also stumbled across that but was hoping for something more comprehensive that caters for the reading as well with integration into PO/OE. I have contacted ACCU-DART regarding this and am awaiting some feedback but was wondering if there is anything else similar to this with 3D...

What are my options for QR (3D) Barcode generating and scanning with Sage 300? Thanks in advance.

They have many other jobs for which they have raised the AR billings manually (marked as job related) without using billing worksheets and the revenue has been recognised correctly via PJC revenue recognition. In my test environment for this client I billed using manual AR job related...

For some reason they seem to have been doing a number of manual AR job related entries instead of generating billing worksheets. Will this mean that when they recognise revenue that these transactions will never be included?

I have a client that uses Revenue Recognition based on Completion (Time and Materials) but they have a number of historical closed jobs that have certain costs that were billed but were somehow not recognised as revenue. How could this have happened? I have only been dealing with them recently...