Hi all,
I'm trying to import a csv of cashbook entries into Sage 200 but I need to create a template csv file first. I have tried on Sage by typing in 1 line of data and then trying to export to csv but it keeps giving me the following error:
Export from batch CB003 - QryCrAccounts: Cannot perform this operation on a closed dataset.
Any assistance would be greatly appreciated 
Thanks,
Erin
Morning Bennie,
I figured out how to resize the image of the error I got
The columns I need to be able to populate in the cashbook batch are:
Date
Module
Account
Account Name
Reference
Description
Deposit
Payment
Tax
Tax Account
Let me know if you need more info!
Kind regards,
Erin
TxDate,Description,Reference,Amount,UseTax,TaxType,TaxAccount,TaxAmount,Project,Account,IsDebit,SplitType,SplitGroup,Reconcile,PostDated,UseDiscount,DiscPerc,DiscTrCode,DiscDesc,UseDiscTax,DiscTaxType,DiscTaxAcc,DiscTaxAmt,PayeeName,PrintCheque,SalesRep,Module,Property,Portion,Service,Meter,Override,SagePayExtra1,SagePayExtra2,SagePayExtra3 17/04/2024,DESC001,REF001,1000,N,,,0,,ABC,Y,0,0,N,N,N,0,,,N,,,0,,N,,0,,,,,N,,, 30/04/2024,DESC002,REF002,1500,N,,,0,,DELTA,Y,0,0,N,N,N,0,,,N,,,0,,N,,1,,,,,N,,, 22/04/2024,DESC003,REF003,2000,N,,,0,,DAKU,Y,0,0,N,N,N,0,,,N,,,0,,N,,2,,,,,N,,, 27/04/2024,DESC004,REF004,3000,Y,1,Vat Control,586.957,,Advertising,N,0,0,N,N,N,0,,,N,,,0,,N,,0,,,,,N,,, 27/04/2024,DESC005,REF005,4000,Y,1,Vat Control,443.478,,Bank Charges,Y,0,0,N,N,N,0,,,N,,,0,,N,,0,,,,,N,,, 27/04/2024,DESC006,REF006,5000,N,,,0,,RCM,N,0,0,N,N,N,0,,,N,,,0,,N,,2,,,,,N,,, 27/04/2024,DESC007,REF007,6000,Y,1,Vat Control,39.13,,Consulting,Y,0,0,N,N,N,0,,,N,,,0,,N,,0,,,,,N,,,
Thanks, Erin
Do the following to resolve your query:
1. Find attached a file called CB005 Cashbook Batch IMPORT.txt. Copy it to your local PC.
2. Rename it to CB005 Cashbook Batch IMPORT.csv
3. Open the CSV file and note the following:
a) Don't delete any columns even if you're not using them. I tested the template as it is and it works just fine to import into the cashbook. Perhaps you can delete one or two columns but then you need to test the effect of doing so.......
b) Keep all columns in the same order/sequence. As you would have realized, there is no Field Mapping feature in the import screen, therefore keep all columns as they are.
c) Add as many rows as required for all your transaction lines.
d) Substitute the Amount and other required columns (e.g. Reference, Description, etc.) values in the various rows
e) Column K - Is Debit: Y = a deposit amount, N = Payment amount
f) Column AA - 0 = Gl, 1 = AR, 2 = AP
g) Column A - Tx Date: I'm using dd/mm/yyyy on my PC's regional Settings and therefore
g1) Ensured the Short Date Format on the import file = dd/mm/yyyy
g2) Selecte the Windows Format option below
4. When done editing the import file, ensure it's saved as a CSV file format and then close it.
5. In the Cashbook batch, ensure all transaction lines are cleared (having no transaction lines and save the batch
6. Go to File | Import and browse for the import file, and import it. (see my options above in g2)
Please advise if you're successful or not
Hi Bennie,
Thanks, it wouldn't work the first time with all (GL, AR, AP) modules entered so I tried an upload with each module separately i.e. only GL, then only AR and then AP. The csv upload worked for the GL and AR modules but I still get the same error as before when I try to import AP module lines.
It seems to be just the opposite error I had when trying to export the cashbook template. I've attached the screenshot of the import error I got this time.
