Adjustment Journals (DIEF)

Inventory and Purchasing

Adjustment journals are used to record changes to both the stock on hand and inventory cost price for products that have been damaged stock, received as bonus stock or need to be returned to the vendor for a specific reason.

  1. Open the required template: GroupsInventoryAdjustments.csv
  2. Edit the spreadsheet as follows:
    HeaderDescription
    JournalNameId

    Mandatory

    Use the name of the journal.

    For example, SOH.

    Description Leave blank
    TransactionDate  
    SiteStore ID
    WarehouseStore ID
    ItemId 
    Qty 
    CostPrice 
  3. Click File > Save as and save as .csv file in an easy to find location. For example, your Desktop.
  4. Click File > Exit to close your file.

    The file must be checked before being imported in Fred NXT Head Office.

  5. Navigate to the file, then right-click the file and choose to Open with Notepad.

    Remove any blank lines at the end or spaced commas at the end of the file.

  6. Press File > Save.

    The file is now ready for importing into Fred NXT Head Office with DIEF.

Use this procedure to adjust the stock-on-hand of products in bulk.

  1. On the FredNXT Head Office area page, navigate to Data Synchronisation > Data Import Export Framework.
  2. Click Processing Group.

    The Processing group window is displayed.

  3. Click to select GroupsInventoryAdjustments, then click Get staging data.

    The Create a job ID for the staging data job prompt is displayed.

  4. Enter a Description, if required, and click OK.

    The Staging data execution window is displayed.

  5. In the Entity Details section, click Folder icon, then select the path to the file you want to import.

    The file is brought into the staging area.

  6. To view details about the file, click Preview, then click Details.
  7. Click Folder icon, then browse for and select the .CSV file to be imported.
  8. Click Run, then OK in the Staging window, then Close.
  9. (Optional) Select Batch mode, then click OK.

    This mode allows you to do other work while the import is processed.

    If no selection is made, the import runs in Client mode. It remains displayed on screen.

  10. Close when successful.
  1. In the Processing Group window, click Execution History.
  2. Click to select the required job.
  3. Click View Staging Data, then Target.
  4. Click Validate, then Post.

    The store's stock-on-hand is not updated until you post the adjustment journal in Fred NXT Head Office.