Importing Excel File into the Supplier Adjustment


You will be able to import the Adjustment Detail from Excel file when you have a lot of the account eg expenses needed to pass.

Save the time to key in 1 by 1 from the Supplier Adjustment screen.



How to use


1) Go to THIS PC -> LOCAL DRIVE C -> SMARTACC -> DYNAMOD -> IMPORT TEMPLATE folder


2) Look for the SUPPLIER ADJUSTMENT.XLSX and double click it to open it




3) Fill in all necessary information as per sample and leave blank (only field as shown below is allowed BLANK) if didn't have information and save the file.

Note: You may copy the original file to your own location and rename the file.





4) Login to Dynamod ->  click SMART (located on the bottom left) -> select 8. ACCOUNTING MODULE -> 2. A/C PAYABLE -> 2. SUPPLIER ADJUSTMENT




5. Click + to add record




6. Fill in the Supplier ID



7. Click MORE


8. Select IMPORT FROM FILE





9) Select the file that you saved earlier.


10) Click OPEN


11) Click IMPORT



12) Click ACCEPT once confirmed





13) Click YES to continue




14) Click SAVE once all information is entered.