UBSA1.18 : Access UBS (Accounting): How to import a Purchase Debit Note
Environment
Access UBS (Accounting)Solution
To import a Purchase Debit Note:
Note: Take a backup of your data before you begin.
- Go to C drive/UBSSTK2015/Data
- In the data folder with Purchase Debit Note transaction, copy and rename the files below:
- ARTRAN.DBF to OARTRAN.DB
- ARTRAN.CDX to OARTRAN.CDX
- ICTRAN.DBF to OICTRAN.DBF
- ICTRAN.CDX to OICTRAN.CDX
- ICTRAN.FPT to OICTRAN.FPT
- Copy the renamed files and paste them in the data folder where you want to import Purchase Debit
- Run the following FoxPro command for example from Ref. No.: PDN00001 to Ref. No.:PDN00005:
- Open and go to 0.File, 0. Exit. You will be prompted 'Are you sure you want to quit the program now?'
- Press the F key on your keyboard to call up the FoxCMD emulator:
- USE ARTRAN APPEND FROM OARTRAN FOR TYPE='SDN' AND REFNO >='PDN00001' AND REFNO <='PDN00005' USE ICTRAN APPEND FROM OICTRAN FOR TYPE='SDN' AND REFNO >='PDN00001' AND REFNO <='PDN00005' QUIT
- Go to Housekeeping, Data Recovery and click OK and then click Yes.
- Go to Transactions, Purchase Debit Note, Check the transaction.
--Source from Access UBS --
Related Articles
UBSA1.50 : Access UBS (Accounting): How to unblock the Debit side
DescriptionHow do I unblock the Debit side during Quick entry when Purchase Return Account is assigned as Master Account? EnvironmentAccess UBS (Accounting) Solution Solution: 1. Go to Housekeeping ,Setup, General Setup, Setting. 2. Uncheck the ...
UBSA1.155 : Access UBS (Accounting): How to include Purchase Return in the SST Return report under column 19
DescriptionHow to setup PTC1 tax code with tax method reporting to Part E (Purchase under Schedule C) line 19 in the SST Return Report. EnvironmentAccess UBS (Accounting) Solution Setup new tax code in the tax code list Go to Maintenance, ...
UBSA1.62 : Access UBS (Accounting): How to Import & Export Master Records
Description How to create new folder with the same chart of account only Environment Access UBS (Accounting) Solution Setup Import & Export: Go to Periodic, Export/Import and select E.I Housekeeping Set the destination: Sub-Directory For ***9.DBF & ...
UBSA1.122 : Access UBS (Accounting): How to print Credit Note bills amount do not appear in Print Statement
Environment Access UBS (Accounting) Microsoft Windows OS 10 Solution Note: Credit Note bills amount do not appear in Open Item Menu Debtors, Print Statement even though it had been knocked off. If you do the knock off through Transactions, Open Item ...
UBSA1.31 : Access UBS (Accounting): How to Search Transaction Check Transactions
DescriptionWhere do I search for transactions in Access UBS? EnvironmentAccess UBS (Accounting) Solution Go to Accounting System, Customer & Sales, Transaction File Maintenance and select Search Transaction. Go to Accounting System, Suppliers & ...