Sage 100

 View Only
  • 1.  Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 11:32
    Edited by Doug Higgs 07-13-2022 11:35
    Version 2020 - The customer has multiple PO landed costs, primarily duty and freight.  When they receive the freight bill they debit freight expense, and the debit duty expense when they receive the duty bill.  However, when a return of goods is entered for a PO, the landed costs get accumulated and credited to inventory variance expense.  This is a mess.  How do you configure Sage 100 to debit the landed costs to expense account defined in PO  landed Cost Maintenance when a PO return of goods is updated?  The end user is currently trying to analyze the variance account to determine what landed costs get reclassified to the expense accounts for PO returns.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 11:39
    To clarify - the end users wants a debit to the landed cost GL accounts on the PO return instead of a lump sum in the inventory variance.  In my original post I put credit and I have now edited it. 


    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 11:54
    Edited by Kevin Moyes 07-13-2022 11:56
    I don't think it's possible.
    Link to Idea.
    Edit:
    And another.

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



  • 4.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 12:53
    Thanks @Kevin Moyes  This is exactly the issue.  I added my vote.


    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 5.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 12:56
    This issue should be a much higher priority than Sage is giving it.  It was reported in 2015.  It don't care how many votes it gets it is fundamental accounting and needs to be fixed.  the voting doesn't necessarily reflect the importance of the issues because many people don't vote.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 6.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 12:59
    Perhaps it's worth adding to the list of questions for the SAGE Development Roundtable call. 
    I wonder if it's on the Mod Squad's list...?

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



  • 7.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 13:07
    Surprisingly enough, it is not.  I think that's one of those things we have given up on.  BUT, no reason not to include it, even if we will get our dreams smashed into small sharp shards that cut our feet to ribbons.

    ------------------------------
    Beth Bowers
    Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
    Tennessee Software Solutions
    (269) 358-0989
    ------------------------------



  • 8.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 13:18
    They did something similar for CM / original invoice costs in v2021, so it might be worth asking... (for advanced features during PO returns and BM disassembly).


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



  • 9.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 13:29
    GOOD POINT!  I've added it in.

    ------------------------------
    Beth Bowers
    Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
    Tennessee Software Solutions
    (269) 358-0989
    ------------------------------



  • 10.  RE: Purchase Order Return of Goods Journal Entries

    Posted 07-13-2022 13:41
    Thanks @Kevin Moyes and @Beth Bowers !
    ​​​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------