Announcements
175
I am having trouble importing SOP data using Integration Manager. Does anyone have experience with this? The problem I am facing is getting the dates to "behave" as I want them. I want to post the transaction (batch) to date #1, and the individual invoices to date #2. This was the sales go to the correct date and the batch can have multiple sales dates.
*This post is locked for comments
Hi James,
The table you need is TX00102 (Tax Schedule Master) - This contains the relationship between Tax Details and Tax Schedules. Bear in mind that there can be many Tax Details in a single Tax Schedule.
Also, table TX00201 contains data on individual tax details - you may be interested in the TXDTLPCT field which contains the tax percentage.
Best regards,
That is the table I have been using. Unfortunately, the TAXSCHID is not what IM uses. I need the Tax Detail ID.
I guess I could have the accounting people give them the same name and it would work, but that is unreliable.
If there any link from the TAXSCHID to the TAXDTLID?
Customer master table is RM00101 - the field you need is TAXSCHID.
(For future reference, click on Microsoft Dynamics GP >> Tools >> Resource Descriptions >> Tables - and you can browse the tables by series. Experience helps a bit in here, but you will find the tables you are looking for).
Try that and let us know how you get on.
Ian.
Well, we are much better off now than when we started. Just need to figure out the tax detail id to use when importing. The Require tax Detail Totals is NOT ticked, so this isn't of concern.
When I say "state," yes I mean US State. The tax in Massachusetts is different that New York and Connecticut, etc. Thankfully our customers are in fixed locations in one state only. So if I can find the customer definition table in the database, I can query the tax detail id and add it to the integration as a Source Field.
Can you point me toward to Customer Card table? And anywhere else that I would need to look to link the tax detail id to the customer number?
Thanks again for all the help.
Can you not default all of the tax from GP? Including the Tax Amount.
When you say state...do you mean state as in geographic location in the US? If you enter the transaction manually, oes everything default? or do you have to edit the tax details?
Check Tools >> Setup >> Company >> Company >> Options. If 'Require tax Detail Totals to equal the pre tax amount' is ticked on, un tick it and try integrating again...see what happens.
Victoria might be able to help more than me on this one.
It is not multicurrency. The problem is related to the Sales Tax Detail Summary area in IM. I can give it the tax Amount, but the Tax Detail ID depends on state. It won't allow me to Set as Default. Not sure where to go with this.
Strange indeed...but I've seen this before...somewhere!
Are these multicurrency transactions?
After you open the transaction, open and save the distribution...can you then post the invoice?
You folks have been such a huge help. The Batch Edit list gives me this error:
**ERROR: The sales distribution(s) does not equal the actual amount.
**ERROR: The taxes distribution(s) does not equal the actual amount.
But, the transaction balances and the totals are equal. When I open the Distribution in GP, it prompts me to save, but I get no error.
Strange.
Are you getting the 'Distribution' error on all transactions?
Print a Batch Edit list in GP - and it will tell you what the distribution error is. - or at least tell you if it is on a line or header level.
Let us know what this problem is and we can suggest a solution.
You can easily have the user who will be posting the SOP batch change the posting date, since it's just one step per batch, prior to posting.
For the other issue - are you importing the GL distributions or letting GP default them? Here is a blog post that might help with this error in general: http://victoriayudin.com/2008/12/08/sales-transaction-entry-gl-distributions-in-dynamics-gp/ (the last question/answer).
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
