Sage 100

I have PO fees that I've linked to a PM work ticket (v2023). 

When I post the PO RoG (with invoice), it posts to the misc item's "Purchases Account" and not WIP... but the WT completion takes the amount out of the WIP account as if the PO amount was posted to WIP.

Is that a bug?  Or am I supposed to set the PO line's GL account to the WIP GL account manually?

I was hoping that linking a PO line to a WT line would automatically override the GL account to WIP, but some local testing (in PMZ) doesn't work that way... unless I missed a setting somewhere?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Hi Kevin - you'll want to have Dynamic Materials enabled for PM so that when you receive any items linked to work tickets, an entry will be made to the Daily Materials Usage Register so that you can perform the secondary update of moving the corresponding dollars to the WT WIP account(s).

------------------------------
Amber Prayfrock, Blytheco
------------------------------

Thank you Amber!  That's the missing piece. 

I do have that option enabled, but was not aware that I had to run the second register.  The amounts are there, which solves the mystery.  Odd that there would not be any kind of warning about this... but I still have to go through the PM training, and I expect it is mentioned there.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 07-18-2024 08:04
From: Amber Prayfrock
Subject: PO charge amounts flowing to WT... override the PO GL Account to WIP?

Hi Kevin - you'll want to have Dynamic Materials enabled for PM so that when you receive any items linked to work tickets, an entry will be made to the Daily Materials Usage Register so that you can perform the secondary update of moving the corresponding dollars to the WT WIP account(s).

------------------------------
Amber Prayfrock, Blytheco
------------------------------

When you update the PO Receipt of Goods/Invoice Register, it will post to the /Misc GL accounts on the /Misc Item in Miscellaneous Item Maintenance.  Then... when you post the PM Daily Materials Usage Register, it creates a JD Transaction to Debit WIP and Credit the original GL Account posted.  It also posts any "applied" burden or Overhead, if applicable. Also assuming Dynamic Materials is Enabled.  

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

oh, looks like @Amber Prayfrock beat me to the punchline. :) 

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 07-18-2024 12:09
From: Madeline Stefanou
Subject: PO charge amounts flowing to WT... override the PO GL Account to WIP?

When you update the PO Receipt of Goods/Invoice Register, it will post to the /Misc GL accounts on the /Misc Item in Miscellaneous Item Maintenance.  Then... when you post the PM Daily Materials Usage Register, it creates a JD Transaction to Debit WIP and Credit the original GL Account posted.  It also posts any "applied" burden or Overhead, if applicable. Also assuming Dynamic Materials is Enabled.  

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

All good.  I appreciate the help!

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 07-18-2024 12:10
From: Madeline Stefanou
Subject: PO charge amounts flowing to WT... override the PO GL Account to WIP?

oh, looks like @Amber Prayfrock beat me to the punchline. :) 

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------


Original Message:
Sent: 07-18-2024 12:09
From: Madeline Stefanou
Subject: PO charge amounts flowing to WT... override the PO GL Account to WIP?

When you update the PO Receipt of Goods/Invoice Register, it will post to the /Misc GL accounts on the /Misc Item in Miscellaneous Item Maintenance.  Then... when you post the PM Daily Materials Usage Register, it creates a JD Transaction to Debit WIP and Credit the original GL Account posted.  It also posts any "applied" burden or Overhead, if applicable. Also assuming Dynamic Materials is Enabled.  

------------------------------
Madeline Stefanou
RKL eSolutions, LLC