Open Forum

The saga continues for billing from the 3rd database.

Back in 2015, in our main database, I created the SOP Integration.  And it has been working since then    The default SITE ID issued was resolved.  Now I have a problem with DISTRIBUTION on the invoices.  With Integration, I do pass the distribution file.  But it did not work.  I did a manual invoice through SOP and it failed.

I did key the distribution.  But the EDIT showed an issue with distribution. 

I am invoicing with a TEXT Item Number not an inventory item number.  Back in 2015 when I started this, I used an inventory part number, but received messages that the quantity on hand was zero.  Using the TEXT item number I did not get that.  Our GP Admin said I needed to create the inventory.  I should him that in the main database, the item numbers I was using were NOT created in inventory.

In the main database something is telling GP to pass the distribution through, or something.  I am not sure how to explain it.  It IS something I need to resolve before next month.

The saga continues for billing from the 3rd database.

Back in 2015, in our main database, I created the SOP Integration.  And it has been working since then    The default SITE ID issued was resolved.  Now I have a problem with DISTRIBUTION on the invoices.  With Integration, I do pass the distribution file.  But it did not work.  I did a manual invoice through SOP and it failed.

I did key the distribution.  But the EDIT showed an issue with distribution. 

I am invoicing with a TEXT Item Number not an inventory item number.  Back in 2015 when I started this, I used an inventory part number, but received messages that the quantity on hand was zero.  Using the TEXT item number I did not get that.  Our GP Admin said I needed to create the inventory.  I should him that in the main database, the item numbers I was using were NOT created in inventory.

In the main database something is telling GP to pass the distribution through, or something.  I am not sure how to explain it.  It IS something I need to resolve before next month.

Back when I started this process, I created ITEM NUMBERS in inventory, DC_MONTH, DC_ANNUAL, and DC_BACKUP.  When I ran Integration Manager, I got errors that there was no product to sell against (or similar warning).  And the Integration failed.

So I deleted those ITEM NUMBERS, and when I integrate, I ITEM_NUMBERS that are the same, DC_)MONTH, DC_ANNUAL or DC_BACKUP.  They are just text identifiers of what I am billing (regarding the services) to the Customer.  

There were no issues, and the integration has been working since 2015.  Now we are moving the process to a different company.  Our GP Administrator said I needed to set the Item Numbers up in the third company as I did in the first.  I kept reminding him that there were no item numbers in the first company.  

He thought they were because when we keyed an invoice manually, the item number DC_MONTH is there.  But as I demonstrated, that is just GP being helpful.  And when he reviewed the inventory, there were no items for the services we billed.  

BUT there are no errors on the distribution either.  The third company does not and will not have inventory.  They sell services only.

Currently, the Integration works, to get the data into SOP for the third company.  But when trying to post each entry has the error regarding distribution.  There is SOP distribution.  Distribution has to be manually keyed for the Item Number.  

There is some setting in the First Company that is not set the same in the Third Company.  The First and Second companies have been established for more than TEN YEARS.  

The saga continues for billing from the 3rd database.

Back in 2015, in our main database, I created the SOP Integration.  And it has been working since then    The default SITE ID issued was resolved.  Now I have a problem with DISTRIBUTION on the invoices.  With Integration, I do pass the distribution file.  But it did not work.  I did a manual invoice through SOP and it failed.

I did key the distribution.  But the EDIT showed an issue with distribution. 

I am invoicing with a TEXT Item Number not an inventory item number.  Back in 2015 when I started this, I used an inventory part number, but received messages that the quantity on hand was zero.  Using the TEXT item number I did not get that.  Our GP Admin said I needed to create the inventory.  I should him that in the main database, the item numbers I was using were NOT created in inventory.

In the main database something is telling GP to pass the distribution through, or something.  I am not sure how to explain it.  It IS something I need to resolve before next month.

Back when I started this process, I created ITEM NUMBERS in inventory, DC_MONTH, DC_ANNUAL, and DC_BACKUP.  When I ran Integration Manager, I got errors that there was no product to sell against (or similar warning).  And the Integration failed.

So I deleted those ITEM NUMBERS, and when I integrate, I ITEM_NUMBERS that are the same, DC_)MONTH, DC_ANNUAL or DC_BACKUP.  They are just text identifiers of what I am billing (regarding the services) to the Customer.  

There were no issues, and the integration has been working since 2015.  Now we are moving the process to a different company.  Our GP Administrator said I needed to set the Item Numbers up in the third company as I did in the first.  I kept reminding him that there were no item numbers in the first company.  

He thought they were because when we keyed an invoice manually, the item number DC_MONTH is there.  But as I demonstrated, that is just GP being helpful.  And when he reviewed the inventory, there were no items for the services we billed.  

BUT there are no errors on the distribution either.  The third company does not and will not have inventory.  They sell services only.

Currently, the Integration works, to get the data into SOP for the third company.  But when trying to post each entry has the error regarding distribution.  There is SOP distribution.  Distribution has to be manually keyed for the Item Number.  

There is some setting in the First Company that is not set the same in the Third Company.  The First and Second companies have been established for more than TEN YEARS.  

The saga continues for billing from the 3rd database.

Back in 2015, in our main database, I created the SOP Integration.  And it has been working since then    The default SITE ID issued was resolved.  Now I have a problem with DISTRIBUTION on the invoices.  With Integration, I do pass the distribution file.  But it did not work.  I did a manual invoice through SOP and it failed.

I did key the distribution.  But the EDIT showed an issue with distribution. 

I am invoicing with a TEXT Item Number not an inventory item number.  Back in 2015 when I started this, I used an inventory part number, but received messages that the quantity on hand was zero.  Using the TEXT item number I did not get that.  Our GP Admin said I needed to create the inventory.  I should him that in the main database, the item numbers I was using were NOT created in inventory.

In the main database something is telling GP to pass the distribution through, or something.  I am not sure how to explain it.  It IS something I need to resolve before next month.

Back when I started this process, I created ITEM NUMBERS in inventory, DC_MONTH, DC_ANNUAL, and DC_BACKUP.  When I ran Integration Manager, I got errors that there was no product to sell against (or similar warning).  And the Integration failed.

So I deleted those ITEM NUMBERS, and when I integrate, I ITEM_NUMBERS that are the same, DC_)MONTH, DC_ANNUAL or DC_BACKUP.  They are just text identifiers of what I am billing (regarding the services) to the Customer.  

There were no issues, and the integration has been working since 2015.  Now we are moving the process to a different company.  Our GP Administrator said I needed to set the Item Numbers up in the third company as I did in the first.  I kept reminding him that there were no item numbers in the first company.  

He thought they were because when we keyed an invoice manually, the item number DC_MONTH is there.  But as I demonstrated, that is just GP being helpful.  And when he reviewed the inventory, there were no items for the services we billed.  

BUT there are no errors on the distribution either.  The third company does not and will not have inventory.  They sell services only.

Currently, the Integration works, to get the data into SOP for the third company.  But when trying to post each entry has the error regarding distribution.  There is SOP distribution.  Distribution has to be manually keyed for the Item Number.  

There is some setting in the First Company that is not set the same in the Third Company.  The First and Second companies have been established for more than TEN YEARS.  

The saga continues for billing from the 3rd database.

Back in 2015, in our main database, I created the SOP Integration.  And it has been working since then    The default SITE ID issued was resolved.  Now I have a problem with DISTRIBUTION on the invoices.  With Integration, I do pass the distribution file.  But it did not work.  I did a manual invoice through SOP and it failed.

I did key the distribution.  But the EDIT showed an issue with distribution. 

I am invoicing with a TEXT Item Number not an inventory item number.  Back in 2015 when I started this, I used an inventory part number, but received messages that the quantity on hand was zero.  Using the TEXT item number I did not get that.  Our GP Admin said I needed to create the inventory.  I should him that in the main database, the item numbers I was using were NOT created in inventory.

In the main database something is telling GP to pass the distribution through, or something.  I am not sure how to explain it.  It IS something I need to resolve before next month.

Back when I started this process, I created ITEM NUMBERS in inventory, DC_MONTH, DC_ANNUAL, and DC_BACKUP.  When I ran Integration Manager, I got errors that there was no product to sell against (or similar warning).  And the Integration failed.

So I deleted those ITEM NUMBERS, and when I integrate, I ITEM_NUMBERS that are the same, DC_)MONTH, DC_ANNUAL or DC_BACKUP.  They are just text identifiers of what I am billing (regarding the services) to the Customer.  

There were no issues, and the integration has been working since 2015.  Now we are moving the process to a different company.  Our GP Administrator said I needed to set the Item Numbers up in the third company as I did in the first.  I kept reminding him that there were no item numbers in the first company.  

He thought they were because when we keyed an invoice manually, the item number DC_MONTH is there.  But as I demonstrated, that is just GP being helpful.  And when he reviewed the inventory, there were no items for the services we billed.  

BUT there are no errors on the distribution either.  The third company does not and will not have inventory.  They sell services only.

Currently, the Integration works, to get the data into SOP for the third company.  But when trying to post each entry has the error regarding distribution.  There is SOP distribution.  Distribution has to be manually keyed for the Item Number.  

There is some setting in the First Company that is not set the same in the Third Company.  The First and Second companies have been established for more than TEN YEARS.  

The saga continues for billing from the 3rd database.

Back in 2015, in our main database, I created the SOP Integration.  And it has been working since then    The default SITE ID issued was resolved.  Now I have a problem with DISTRIBUTION on the invoices.  With Integration, I do pass the distribution file.  But it did not work.  I did a manual invoice through SOP and it failed.

I did key the distribution.  But the EDIT showed an issue with distribution. 

I am invoicing with a TEXT Item Number not an inventory item number.  Back in 2015 when I started this, I used an inventory part number, but received messages that the quantity on hand was zero.  Using the TEXT item number I did not get that.  Our GP Admin said I needed to create the inventory.  I should him that in the main database, the item numbers I was using were NOT created in inventory.

In the main database something is telling GP to pass the distribution through, or something.  I am not sure how to explain it.  It IS something I need to resolve before next month.

The saga continues for billing from the 3rd database.

Back in 2015, in our main database, I created the SOP Integration.  And it has been working since then    The default SITE ID issued was resolved.  Now I have a problem with DISTRIBUTION on the invoices.  With Integration, I do pass the distribution file.  But it did not work.  I did a manual invoice through SOP and it failed.

I did key the distribution.  But the EDIT showed an issue with distribution. 

I am invoicing with a TEXT Item Number not an inventory item number.  Back in 2015 when I started this, I used an inventory part number, but received messages that the quantity on hand was zero.  Using the TEXT item number I did not get that.  Our GP Admin said I needed to create the inventory.  I should him that in the main database, the item numbers I was using were NOT created in inventory.

In the main database something is telling GP to pass the distribution through, or something.  I am not sure how to explain it.  It IS something I need to resolve before next month.

The saga continues for billing from the 3rd database.

Back in 2015, in our main database, I created the SOP Integration.  And it has been working since then    The default SITE ID issued was resolved.  Now I have a problem with DISTRIBUTION on the invoices.  With Integration, I do pass the distribution file.  But it did not work.  I did a manual invoice through SOP and it failed.

I did key the distribution.  But the EDIT showed an issue with distribution. 

I am invoicing with a TEXT Item Number not an inventory item number.  Back in 2015 when I started this, I used an inventory part number, but received messages that the quantity on hand was zero.  Using the TEXT item number I did not get that.  Our GP Admin said I needed to create the inventory.  I should him that in the main database, the item numbers I was using were NOT created in inventory.

In the main database something is telling GP to pass the distribution through, or something.  I am not sure how to explain it.  It IS something I need to resolve before next month.