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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SOP Serial Number & Others

(0) ShareShare
ReportReport
Posted on by

Help Required. We are using GP 10.0 with SP3 running on SQL Server 2000. We are using SOP module and our customers require us to capture their Purchase order serial numbers against each of the line items in the orders & invoice. Is there any option available in GP 10.0 to have serial numbers against each line item. The serial numbers may not be in sequential form.

Also, is there any way, a customer order in GP 10.0 can be converted only to a delivery ticket affecting only the stocks on hand. The process is as follows. We get customer orders from customers and we despatch the materials to the customer. At this point we want the stocks to come down to that qty. After a couple of months based on the customer feedback on consumption, we do billing for them. So we cannot convert the order to an invoice until such time the customer has replied and it may take a couple of months before we can invoice them. How can we go about this in GP 10.0

Another query is with respect to the Salesperson ID. We want to capture the Sales ID against each order in SOP module and based on the Sales person, the distribution in the invoice needs to be changed according to the SR ID. Is this possible in GP 10.0

 Any help in clarifying these will be of immense help.

 Mani

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    Re: SOP Serial Number & Others

    If your inventory items are set up to be tracked by serial numbers, when you enter one on a sales invoice, you will be asked to enter the serial number. If the quantity is 10, you have to enter 10 serial numbers etc. Also Lot tracking is available.

    In terms of shipping withoutinvoicing you have a few options.

    1. Use a seperate fulfillment process, so that you can ship the goods without invoicing.

    2. Process the sale all the way to Invoice, but don't print the invoice. When the custoer comes back with feedback on consumption you can adjust the invoice accordingly...recording how much of what was delivered will be invoiced this time. Eithre you end up cutting another invoice for the remaining balances or you process a return if the customer sends he unconsumde portion back.

     On the salesperson ID defaulting the sop distribution. This is not available in GP. You can default using the inventory site ID...perhaps ifyou are not using sites too much...you could set up a site for each salesperson...this will of course only change the GL account segment that is set to be the site ID.

    There are 3rd party products available for defaulting GL account codes basd on a number of criteria. Do a search for previous posts about defaulting GL codes and there are a few references to one product in particular that might do what you want. The alternative is to create a custom table of salesperson ID's and their default GLaccount code...and create a trigger that overwrites the SOP distribution based on a value in this table. Or...you could change how you report and get your salesperson analysis from the Sales Module in GP rather than relying on the GL.

  • Community Member Profile Picture
    on at
    Re: Re: SOP Serial Number & Others

    Hi Ian,

     Thanks for this input. But I still think i may have missed in conveying my issue correctly.

    1. As for the serial numbers. Tracking by serial numbers options would not be apt for us. It tends to increase the document creation job for users. What i really wanted was this. For a customer A, he has issued a tender for products X, Y and Z. The tender doc uses the serials agains each as 1, 2 and 3 respectively. But when finally releasing the order, the customer A says that our co. has won the order for products X and Z. So the PO says items 1 and 3. Now while i deliver the materials to A, i should have 1 and 3 against the prods X and Z in my system too. Basically i need to capture the numbers on the PO against the items as in the customers PO. Hope this clears what i am really looking for.

    2. For separate fulfillment process, i have seen that the Qtyonhnd does not reduce for the item until the invoice is posted. I want to reduce the qtyonhnd as the delivery takes place and for all fresh receipts against the item, i want the weighted average cost calculated on the new stocks after considering this issue and after a couple of months, i need to invoice the customer. Basically, i want to use the SOP module to have only inventory effect and no AR and GL effects. Basically, is it possible to halt the document from posting to AR. Even if i am able to have that in the work file of AR it would suffice. Is there any way to achieve this.

    3. For sales person ID, i have customised codes doing as per your suggestion already and its working fine. Probably i shall look for a more robust 3rd party software if availble on the forum.

     Ian, if you could reply to me on these it would be very helpful. Also is is possible that i could call u and clarify exactly on what i am looking for. If its ok with you kindly give me your coordinates and the timings when i could speak to u. For your info, i am in Oman and we are GMT +4.

     Regards

     

    Manikandan

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans