When I transfer orders to invoices, I get four lines of distribution:
Receivables - DebitSales - CreditCosts of Goods - DebitInventory - Credit
I understand how this works. It is really a 'slick' process.
From an external database, I have invoices that I need to bill through GP2015 (existing customers). In my application, I have I generated the invoices, the line item of the invoices and the distribution. I ran through it on Friday. One part did not work as I thought. I tweaked it and the integration went with no errors. Thanks to assistance I got on another thread.
In the distribution I need to pass the four items noted above, as well as an additional pair. I need to pass the Costs of the Invoice as if I was transferring an order. COGS was not allowed as a type in the distribution. Is this because there was no costs amounts in the ITEM import.
If I pass UNIT COST to the line item, will I be able to use the COGS type. I used MISC pass information to Cost of Goods Sold, Inventory, and Payables. As such, the related costs did not show in a report that the VP ran for the revenue that was integrated.
I hope this makes sense.
I have been playing in our test company with this. I do not know if it is possible, but what I think I need is a Part to bill:
1) Quantity is ONE2) Unit Price is variable per customer's invoice3) Unit Cost is variable per customer's invoice.
I can create the item to accept a variable Unit Price. But I cannot add a cost. I have tried creating a Part that was Inventory, Service, and Flat Fee. For my initial run of this, I had 83 items.
I am testing by hand-entering... but the final tasks will be uploaded via Integration Manager.
Thank you for responding. I have tried to create an ITEM NUMBER that was of these ItemTypes:
Sales InventoryMiscServicesFlat Fee
I was not able to put a cost in for any of these. I can hit the cost of good sold account in the distribution but using the MISC type to code to it. But then when reports are run on sales, there is ZERO costs associated with the sale. That is what I am trying to accomplish.
I am wanting to invoice customers for a service that has a related cost of goods. I am using Integration Manager to upload the information to GP2015r2. I have a little program that tracks the information. With it, I can write the needed text files for Integration Manager to upload.
Each customer will have a charge for a variable amount and the cost is likewise variable. When the "higher ups" run the reports, I need the sales that I upload to have the related costs so that the margins will not be skewed.
Is there a way to set up the "part number" that I can pass the sale value and the cost value into the transaction. What I did worked great from the customer perspective. But failed from the back of house perspective. The report was sent to Excel, so the missing costs could be added manually. That worked for one time, not on-going.
My eyes are crossing from staring at the screen. Thankfully it is a long weekend. I will not have to attack this until Tuesday.
Andrew, I truly to appreciate your assistance. I better understand how Great Plains works. It is just that I have a billing scenario that is not fitting (at the moment).
After I have this mastered, I get to learn how to implement Contract Administration so I can get rid of the external program I use that I upload to bill customers. Oy Vey
You don't really make a non-inventory item. It doesn't exist in the item master card. You just import the item number and description into the SOP line.
Make sure your SOP setup is set to allow non-inventory. You can try it manually first. Go into SOP entry and create an invoice and type gibberish for the item number. You'll notice it now lets you enter the unit cost.
Thank you both for responding. I went to our test company, and I typed in a gibberish part number. When I tabbed to the next field it asked me if I wanted to save it. I responded No. It would not let me advance further. So I said Yes, and it took me to the Item set up card.
I am going to try an upload in the test company to see how it works, or bombs. I have an extension of one week to try to work out a solution.
Go into your SOP setup Options and make sure it is checked to allow non-inventory items. Tools >> Setup >> Sales >> Sales Order Processing >> Options.
If you've found this thread useful, dive deeper into User Group community content by role