Feature - Warehouse Receiving Posting to Optionally Create a CSV File

Feature - Warehouse Receiving Posting to Optionally Create a CSV File

Release date: 5/1/2021

Version 8.5 & Up

In PO -> Processing -> Warehouse Receiving Process, the user can now optionally create a CSV file upon the posting of PO Warehouse Receiving. To enable this feature, you need to go to Global Setup --> Dist --> PO Warehouse Receiving:

    12. Create CSV Upon PO Whse Receiving Posting?

The default value is "N." See sample screen below:


If you enter "Y," the following window will appear:


This screen shows the layout of the CSV file that will be created is as follows:  
  • PO Number
  • PO Line Number
  • Product Code (i.e., Item Number)
  • Quantity
  • Import Date
  • Serial Number
  • Status - Hard code to "A" at this moment
You will specify the file name and path for the CSV file. Note that the date and time masks are supported. Let's say right now is 05/04/2021 10:17:30AM. The following mask will be transformed to corresponding values:
  • YYYYMMDD: 20210504
  • YYMMDD: 210504
  • YYMM: 2105
  • HHMMSS: 101730
So the above example will cause the creation of f:\nsi..pjt\85\dlm\rzanwms\qr20210504101730.CSV. The mask can be part of the file name or path. It's optional for you to use it. During the process of creating this CSV file, if the file does not exist, the system will create the file with a TMP extension first. After it is done, the system will then rename the TMP file to a CSV file. On the other hand, if the CSV file already exists, then the system will append to the existing CSV file.

The "Only Send Serialized Items in this CSV File?" flag by default is "N." If you set it to "Y," then only serialized records will be exported to the CSV file -- one serial record per line and the quantity will always be 1 (one). 

This feature is related to the following feature:


Modified programs: NSCTLFIL.FD, NSCTLFIL.W38, NSCTLINI.CBL, NSCTLMN3.CBL, POWHRPST.CBL

DLM














    • Related Articles

    • Feature - Use PO Warehouse Receiving CSV Import for Validation & Creating Another CSV File

      Release date: 4/30/2021 Version 8.5 & Up Generally speaking, P/O Warehouse Receiving CSV Import ( PO -> Utility -> Warehouse Recv Import) is used to create warehouse receiving transactions. In some unique situations, the user may not want to create ...

    • Feature - Warehouse Receiving Mass Receiving

      Release date: 11/18/2017 The following changes were made to PO --> Processing --> Warehouse Receiving process A new option has been added: Mass Receiving. Warehouse receiving records (POWHRECI) are created using passed values from the screen program, ...

    • Feature - Create Hold Trx when Posting Inventory Trx

      Release Date: 12/21/2020 Version 8.5 & Up In PO Warehouse Receiving File Maintenance, a "Create Alloc ?" flag exists to signify that during posting of the transactions a record will be created in the Hold Transaction file. That is to say that even ...

    • Feature - Warehouse Receiving Allows Overriding of Allocation/Hold Descriptions

      Release Date: 12/28/2023 Version: 8.5 and Above Background Since 12/21/2020, in Purchase Order & Receiving > Processing > Warehouse Receiving Processing, users have been optionally allowed to put a receiving item on hold after posting the receiving ...

    • Presales Posting

      Release Date: 3/1/24 Version: 8.6 and Above Presales Posting will move Presales Transactions to Presales Pending. This can be done either after performing the import or manually adding the Presales Transactions. Presales posting will cause the ...