I need some detailed information on what and where to pull data in Dynamics for an invoice? And, what tool should I use to Import and Export this data?
What information do I need for a new document - a Debit Adjustment?
It goes in the Voucher & Adjustment screen as an Adjustment document type (rather than as a Voucher.)
Then there's a RefNbr field on the Apply Adjustments tab where you can optionally enter the RefNbr you want to apply it to.
I rarely enter Adjustments.
Wheb I do enter one, I just let it get caught up in the next Cheque run.
So I don't think I've ever used that "apply to" field.
And ve never tried it in a TI
So I don't know how it will work for you...
Barry
Thanks, you have been great help to me.
Barry,
In the following data file that you have posted above; some values are enclosed with double quote and some are not. Initially I thought that you have all string values enclosed with double quote but there are some other string values that are not.
Batch,199912,0,000002,12/16/2008,CAIRO,,,,SYSADMIN,
Document,"VT0100","5435435",,,10,"","","CO123000","","","","","BAS","","","","","","",,,"","","VO",0,,"","","","","","",0,0,,,"","","","","","","","","","","","",0,0,0,0,0,0,0,0,,,,,
Transaction,"","",0,0,"","","","","CO123000","0000000",10,"","","","C","","","","",0,0,,,"","","","","","","","","","","","",0,0,0,0,0,0,0,0,,,,
"Batch,Change",199912,10,000002,12/16/2008,CAIRO,,,,SYSADMIN,
As you no doubt know, the idea of having string fields in double-quotes is to protect against a field, such as Name or Address, containing a comma.
That will be interpreted as "end of this field" and you get a bit of a mess.
If such a string field is in double-quotes, there is no problem.
(Of course, you have to be careful of a field which itself includes a double-quote. The general rule is that you replace the single "double-quote" with two "double-quotes".)
You probably knew all that.
So as you noted I have generally enclosed all string fields in double-quotes.
Looks like I missed some fields in the "batch" line.
Actually most of those are "safe" anyway - they won't hold a comma. But it is conceivable that some of them might hold a comma, so I should have put those string fields in double-quotes too.
I am still getting three errors in Level 4; pplease take a look...
1. Default 1099 field is disable; how do I enable it?
2. My Input file and Control File does not contain cprojectid; why is it giving me error on this field?
3. The error file indicates "Number of error: 3" but I find only two; why?
Data File (input):
Level0,,199904,B,650,,,,,,,,,,,,,,,,
Level1 ,,VO,MSQ01,4/4/1999,04041999CR,4/4/1999,01,650,0,A,,,,4/4/1999,4/4/1999,4/4/1999,,,0060,2050
Level4,0060,Invoice,4030,0,650,1,International Business,,,,,,,,,,,,,
Control file:
case 4 ' 4 of 8
'Level 4 if of Type D
' Field mask is UUUUUUUUUU
' NOTE -- This field is a required field
serr = SetObjectValue( "ccpny", ImportField(1) )
' clinetype is an Combo Box
' Values are N;Invoice,C;Misc Charge,F;Freight,S;PO,D;Drop Ship,R;Receipt,P;PPV,T;Tax
serr = SetObjectValue( "clinetype", ImportField(2) )
serr = SetObjectValue( "cacct", ImportField(3) )
serr = SetObjectValue( "csub", ImportField(4) )
serr = SetObjectValue( "ctranamt", ImportField(5) )
' cboxnbr is an Combo Box
' Values are 1;1 - Rents,2;2 - Royalties,3;3 - Other Income,4;4 - Federal Income Tax Withheld,5;5 - Fishing Boat Proceeds,6;6 - Medical and Health Care Payments,7;7 - Nonemployee Compensation,8;8 - Payments in Lieu of Dividends/Interest,10;10 - Crop Insurance Proceeds,13;13 - Excess Golden Parachute Payments,14;14 - Gross Proceeds Paid to an Attorney, 15;15a - Section 409A Deferrals,25;15b - Section 409A Income,;<None>
serr = SetObjectValue( "cboxnbr", ImportField(6) )
serr = SetObjectValue( "ctrandesc", ImportField(7) )
case 5 ' 5 of 8
Error:
'System Message 8011: ========Begin Processing of a Level1 Data Line========
'Level1 ,,VO,MSQ01,4/4/1999,04041999CR,4/4/1999,01,650,0,A,,,,4/4/1999,4/4/1999,4/4/1999,,,0060,2050
'System Message 8005: New Record Requested
'System Message 8012: ========Successful Processing of a Level1 Data Line========
'System Message 8011: ========Begin Processing of a Level4 Data Line========
'Level4,0060,Invoice,4030,0,650,1,International Business,,,,,,,,,,,,,
'System Message 8036: Invalid attempt to populate a disabled field: cboxnbr with value: 1
'System Message 8034: Error in Field: cprojectid Value:
'System Message 2: Data must be entered in this field
'System Message 8012: ========Successful Processing of a Level4 Data Line========
'System Message 8030: The Number of Errors detected was 3
'System Message 8001: Completed Processing 22:45:55
<< 1. Default 1099 field is disable; how do I enable it?
Don't know much about 1099 - it doesn't apply where I live. There are SetUp options about it.
<< 2. My Input file and Control File does not contain cprojectid; why is it giving me error on this field?
The errors seem to be
<< 'System Message 8034: Error in Field: cprojectid Value:
<< 'System Message 2: Data must be entered in this field
Project Id can be compulsory, depending on SetUp options, and the Acct ebtered.
So maybe it is complaining because you are not populating it.
You will notice in my sample file that it detects whether Project & Task are Enabled. If so, they get populated.
Try entering the same data into the screen manually.
Does it want you to enter something in ProjectId?
<< 3. The error file indicates "Number of error: 3" but I find only two; why?
There are three errors.
<< 'System Message 8036: Invalid attempt to populate a disabled field: cboxnbr with value: 1
All imported successfully. Thank you so much.