Sage 100

We have a situation for a new customer ramping up on Job Cost (v2018), and they want their GL accounts used to be very granular. Down to the cost type level (not just job type), with a GL segment within the WIP / cost accounts coming from a job UDF (for salesperson). So, if we turn off WIP, we can (in theory) use a script to substitute the last GL segment when doing AP invoice entry (or entering a PO) so the costs get posted to the desired account. But that means they have to handle WIP manually at month end. If we turn on WIP, we could probably put the WIP into specific GL accounts with scripted changes, but when closing jobs (to push WIP to costs) is there a way to override the GL accounts at that stage? (So the WIP comes from the right segment, and the costs go to the correct account, according to the cost type settings and Job UDF... NOT just using the accounts from the Job Type).

Although not obvious, the Job Close-Out Report is actually a journal/register (even as a legacy module) with an Update (posting) program. You can see it has no business object ergo not conducive to scripting. I took a look anyway to see if there could be a scripting entry point in the _UPD where the Populate Work Table is done where WIP is moved out but it does not have one (sometimes there are SetValue's and PreWrite's you can jump into depending on what you need to do). However, doing GL segment substitution for WIP during the Close-Out Report is suited for a traditional mod.

Thanks for the timely response Alnoor. It is greatly appreciated! We were fearing that it was a direct journal / register process without an entry point for scripted changes. Since we are still early in the setup / configuration process we'll probably go with WIP off / direct postings to the correct cost account, and if they complain about managing WIP manually, the custom programming option can be brought up then.