Invoice posting error

[wwwedward]

I am starting to get an increase in this error during invoice posting.

“The above record has not been posted due to an error occurring during inventory allocation”. The dollar amount for the whole posting session is off by the amount of a single order detail for 7 cases of an item. Re-running the reset allocation corrects the inventory and indicates a problem with the item in question from the invoice posting session. What file is not getting the correct information at order creation or whatever???

7.5.103f sql 2000 sp3

Thanks

 

[MacolaHelp]

I have seen this at one of my sql sites. They use feature items & serialized inventory. The situation is that the order is partially posted to various tables. Once partially posted, you must analyze the affected files to determine how to fix. To alleviate this problem & eventually be rid of it, I recommend running the pre post register to screen before posting invoices to detect your potential problems. Then print a duplicate invoice on the problem orders, indicate the invoice is NOT ok, unselect & rebill the order until it goes through properly. Sometimes this doesn't work. If so, after unselecting the order again, resetting allocations will usually correct the problem. You might also try to run the reset allocations as a deferred process each night, spooling to file, until the problem goes away.

 

[wwwedward]

The allocation reset function can be scheduled via macola or sqL?

 

[MacolaHelp]

macola. IM/processes/reset allocations/check inv trx box/send to file/choose the defer check box/schedule a time/leave one workstation running the deferred reports processing screen in system manager so the job will process overnight.