Recent content by devoted

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.