web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP9: SOP / Inventory

(0) ShareShare
ReportReport
Posted on by 3,055

Customer Service accidentally posted a sale through SOP for an inventory item without allocating the lot number associated with the sale.  From what we can tell, GP used the inventory card to get the cost of the product and posted that value to the general ledger's CGS account.  The subledger though for inventory did not remove the volume because no lot number was selected. So, our subledger compared to g/l do not tie.

First, why does GP allow a sale through SOP to be posted for an inventory item being tracked at a lot number level with no LOT # assigned/allocated?  The item maintenance shows the Item Type as "Sales Inventory".

Secondly, we were going to correct the sales side by doing a return with no lot # then reinvoice and allocate the lot # to the sale.  Interestingly, GP will not allow us to return an item without assigning a LOT #.  Is that true?  In essence, GP prevents a return from happening without a lot # being assigned, BUT it will allow a sale to go through without a lot # assigned?  Can someone explain this?  Do we have a setup feature for SOP wrong which is allowing this to happen? 

 

Thanks,

Dale

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,625 Super User 2025 Season 2 on at

    The customer service person should not have been able to proceed with processing the invoice without supplying a lot number.  They should have received an error message that would have stopped the transaction until the lot # was supplied.  There is nothing in setup that would affect this.  When lot or serial tracking is turned on in GP, every transaction of a tracked item requires lot/serial numbers be selected.

    Are you 110% sure the item on the invoice is the same as the inventory item, i.e., could it be the customer service rep added a period, comma, or some other character to the item number, essentially making it a non-inventory item?

     

  • Dale Coulthard Profile Picture
    3,055 on at

    Thank you for the quick response.  We are 110% certain that the item # used in SOP was the inventory item.  First, if an item number at the SOP level is used which is not setup in inventory maintenance as an inventory item, then at the time of posting, GP will state that there are no accounts assigned and force the person to go to the distribution level and code the transaction.  Our customer service members are not accountants, so they do not know what accounts to use.  Secondly, I ran an analysis cubes report for this customer.  If the item number used had not been "inventory" (if the spacebar was hit to create a space), the data warehouse would reflect that sale separate from other sales.  It did not.

     

    Best regards,

    Dale

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,625 Super User 2025 Season 2 on at

    I meant to ask this in my 1st post but what version and release of GP are you on?

  • Dale Coulthard Profile Picture
    3,055 on at

    We are using GP 9.00.0281

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans