Sage 100

Client recently upgraded from 4.10 to 4.50. Randomly, Sales Journals are generating out of balance GL Postings. I have analyzed the invoices every which way to Sunday and cannot find a pattern or reason for this occurring. I was able to match in one batch 8 different invoices where some of the invoiced inventory items' COGS postings posted twice which is the source of the out of balance GL postings. I have searched the KB, here and the Sage Community Forum and am coming up empty handed. Anyone run into this?

What service update are you on?

Any integrations/imports?

.4 All Sales Orders are entered manually in Sales Order Entry and then invoices manually entered in Invoice Data Entry.

This sounds like the problem in PU1 if I remember correctly.

They never were on PU1 ... is there some article or documentation you can refer me to. Maybe the problem has come back.

This is what I remember http://community.90minds.com/2012/01/21/sage-indicates-fix-for-sage-100-erp-v4-50-formerly-mas-90-and-200-sales-order-double-posting-is-imminent/

In Sales Order Journal Update, the Daily Transaction Register no longer double posts invoices when the journal has been printed and updated in the first pass. 11 DE 98228 KBID 112734 Resolution ID 540417

I think the dtr was in balance with that other issue though. Might be something similar to look for.

I don't think these are quite the same issues.

I've done a few - not running into this on 4.5 -- odd.

Though I probably have not put in the very latest -- PU4? - for most of my upgrades so if you're at PU4 you may be uncovering a new issue -- or at the least I can't rule that out. I think all my upgrades have been PU3...

I have had this with a client but it's for a very specific instance. Somewhere along the line, (I have guessed it was when items were originally imported), Kit items were set to Standard as the Valuation method. (Which you can't do if you set one up manually.) Client uses a kit but makes a change to the lines on the kit. This produces a variance which posts to a variance account, but one-sided. Client is working on changing valuation methods, but slowly.... so it still happens. This is on any version of 4.5.

I've had a couple on PU4, and we haven't had any issues like this. Not much help, I know.

Can you narrow it down to an item level?

I'm not sure if the kits are the problem or not ... some of the items causing the GL double postings are non-kit items, but in my analysis I could have been assuming wrong invoices that posted out of balance .. I used Microsoft Solver to go through nearly 100 invoice lines and total cost of each item to see which ones added up to the out of balance amount. It is possible that the 8 invoice lines that added up to the total amount were not the only combination to come up with the amount. I did see something on Standard Valued kits in my research along the way, but assumed that was not my problem because of the invoiced lines that Microsoft Solver pointed me to were not all kit items ... just standalone items. Thanks everyone!

Do you know what GL looks wrong or is missing? Do they adjust the tax amt on the invoice?

this sounds a lot like the earlier issue that was supposedly fixed. On that one if you previewed the journal, said no to post, and then printed a second time, it would post correctly. Otherwise random lines would be duplicated in the GL causing an out of balance DTR. But the sales journal would be correct.

@DianeRuth I identified that it is the COGS postings that are sometimes doubling up; they do not have any sales tax on these invoices.

The problem is not the Sales Journal having wrong information ... it is the Daily Transaction Register that is out of balance.

I think Al is on the right track. At least try to rule it out. I think my temporary work around was to preview ir they weren't going to update. It wouldn't be the first time that something was ""unfixed"" by Sage. I think it was during v4.4 beta that if you didn't update the PR DTR when prompted the first time, that the GL's disappeared entirely. Little comfort to the early adoptors...............

I had this issue, I beleive it is fixed with SU3. That said I did put a single patch on SO4081T, see if this still applies.

Customer is installed on PU4 @RonPeterson

Jane, I hear you though who knows SU 4 may not have the fix. I would download SO4081T, remane the orginal SO_SalesJournal_upd.pvc, put the tow files from this patch in place and see if the issue is resolved.

Oh, Oh, According to the PU PDF, SO_SalesJournal_upd.pvc was modified in this release. The bug could very easily have been reintroduced. This needs escalation to support if that is the case............

Has Sage been contacted about this? this is a pretty big deal if the bug has resurfaced.

Have you reinitialized the SO Invoice data entry files?

Update.... it's a bug, not an old one that has arisen, but a new bug. I will give the details after I have it documented and reported to Sage. Thank you to everyone's comments and contributions!

OMG - I have upgraded 5 clients in the last 4 weeks. OH NOES. :-(

While I did find that the client did have some kits as Standard Cost valued which also caused GL posting problems (I will be changing these valuations to Average), the new problem is with Average costed kits not posting COGS and not posting Revenue. I don't know if it is all Average Costed Kits or just some. Doing further investigation and will update the post when I have all the dets.

I feel better. I have few people using kits. Although I had just gotten off the phone with someone who DOES and had assured him he was good to go on upgrading to 4.5. :-(

I believe the problem has solely to do with Kits that they had some of these inventory items valued at Standard Cost, even though some of the GL postings that were incorrect did not point to items that were a Standard Valued exploded kit parent. I spent so much time trying to figure out what caused the problem: I converted the GL Daily Posting PDF register to Excel, and matched up all the COGS postings with the Inventory relief and found where the duplicate or just plain wrong GL postings were generated from. None of them seemed to point directly to the Standard Valued Kit Parents. But I had copied the invoice batch before it was updated and all the company data to a testing company. I identified all the standard cost exploded kits parents and manually changed their Valuation to 2. I also made sure to change the Valuation in the inventory item. I then posted the invoice batch in the test company and Daily Transaction Register posted perfectly in balance. Today I used VI at the client to change the valuation of all Standard Cost Kit parents to Average Cost (after they posted their invoice batch). Even though they weren't supposed to have these as Standard valued, they must have imported their inventory items way back when. They have been a MAS 90 client for over 10 years. And even when they were on 4.10 they had no out of balance GL postings from invoices batches, so the rewritten inventory module in 4.40+ must have now made GL post out of balance. I will know for sure if this problem is completely cleared up when they update a new invoice batch tomorrow.

Yes ... problem solved! It was solely due to those dang Standard Cost valued kits, even though it wasn't at all obvious that they were the culprint. They posted a large invoice batch today and it posted to GL in balance! Happy Friday y'all!

I would delete any sales order, invoice, and shipping data entry screens and recrete the screens if they are customized. I had a case with Sage that went on for a year. The problem is the lines were not being all copied to the shipping data entry screens randomly. Sage finally identified the bug after watching many hours of video of them performing their tasks. The latest SU 4 should have the latest fixes.

@JaneScanlan - how weird that you and I both ran into that!

Thanks @BethBowers for steering me in the right direction.

So is it a bug or a wad?

IMHO, it's both. It's a bug that you can somehow get a kit set to Valuation method of Standard, but it's a result of that and WAD that it sometimes posts out of balance.

4.30 to v2015 Upgrade: On 4.30 the DTR generated perfectly fine from S/O Invoice Entry (with an exploded Kit item), i.e., _not_ out of balance. On v2015, the DTR is out of balance; appears the credit to Inventory is present but not the debit to COGS. Per the above thread, I changed the Kit item's Valuation to Average Cost (from Standard Cost), and that resolved it. Anyone recall that being a specific programmatic changes at some point after 4.30?

_Cont'd from above post_: Just remembered (re-realized) that Kit items cannot be set as Standard Cost Valuation (or Lot or Serial), of which I _thought_ it was strange that some of the client's Kits were set as Standard. So similar to what's mentioned in the above thread, somehow these Kit items got incorrectly set as Standard Cost. **Why are Standard, Lot and Serial Valuation methods Not allowed for Sales Kit Product Type** Products Sage 100 Description Why are Standard, Lot and Serial Valuation methods Not allowed for Sales Kit Product Type Resolution Serial, Lot and Standard valuation methods are not available to select for KIT type items. This field setting defines the item costing method of a particular item and determines the cost value to be used in the GL posting. It is not designed for item tracking. The kit cost varies depending on whether the kit is exploded (shipped at the component level) or not exploded on Sales Order. A kit type item that is exploded uses costs that are associated to the kit components, not the kit item. The component lines of a kit item that are exploded on the sales order may be changed on the order or during invoicing. This can significantly impact the item cost. The Bill of Materials module allows an item bill to be set up as a Kit. A kit type Bill may have Options that impact the item's actual cost significantly. A costing method of lot and serial cannot be applied since the kit item is not being processed from inventory and no direct cost being associated to the Kit item. The need to assign serial or lot costing methods to assembled items can be met with the Bill of Materials module. The Standard valuation/costing method is not an available valuation type selection for the same reasons as stated above. An exploded Kit item will use cost from the components of the kit not the cost of the kit item. To create an item that is a ""Kit"" and be able to use the costing method of Standard, Lot or Serial, you must first create the item in Item Maintenance with a Product Type of either Finished Good or Raw Material and then create a standard type Bill for this item in the Bill Of Materials Module.