SaleUnit priceBatch entry †
- SaleUnit priceinformation managed at its company is edited in Excel (CSV), the SaleUnitpriceinformation is summarized on a number screen and Read-in sees it.
Since the file [ CSV output / file / 【SaleUnit priceList】 ] becomes origin, it becomes the format which the upload file also united there.
If Batch processing (Entry and Delete) is not data of Effective date of Latest, it cannot be Entr(ied).
| Query item name | Explanation |
|---|
| Register type | Specify Entry or Delete. |
| File name | Specify the full path of the storing place and File name of a file which perform Batch processing. |
| Input item name | Character | Number of bits | Mandatory | Explanation |
|---|
| Customer | alphabet/number | 6 | ○ | Customer code Entr(ied) by Customer master is inputted. |
| Customer item | - | 30 | ○ | Customer item Entr(ied) by Primary table for customer item change information is inputted. |
| Order quantity's upper limit | number | 12,4 | ○ | The maximum value of Order quantity which is in charge of a Quantity discount is inputted. |
| Unit | | - | | Reference Item at the time of CSV output 【SaleUnit priceList】. Even if it inputs, Update in particular is not carried out.Quantity unit of Order quantity. |
| SaleUnit price | number | 16,4 | ○ | SaleUnit price is inputted by larger value than zero. |
| Currency | | - | | Reference Item at the time of CSV output 【SaleUnit priceList】. Even if it inputs, Update in particular is not carried out. Currency of SaleUnit price. |
| Unit price classification | | | ○ | Unit price classification by which Code management is carried out is inputted. 0:FormalUnit price |
| Effective date | year/month/date | - | ○ | Start date of the Valid term of SaleUnit price is inputted. Time can also be No.t inputted. |
| Expire date | | - | | Reference Item at the time of CSV output [ 【SaleUnit priceList】 ]. Even if it inputs, Update in particular is not carried out. At the time of Day which the next of inputted Effective time Minute(d) Effective time-1 |
| Customer name | | | | Reference Item at the time of CSV output 【SaleUnit priceList】. Even if it inputs, Update in particular is not carried out. Customer name Entr(ied) by Customer master. |
| Customer item name | | | | Reference Item at the time of CSV output 【SaleUnit priceList】. It is used for automatic Entry of Primary table for customer item change information. |
| Plant | Character | | | Reference Item at the time of CSV output 【SaleUnit priceList】. Even if it inputs, Update in particular is not carried out. |
| LatestUpdate person | Character | | | Reference Item at the time of CSV output 【SaleUnit priceList】. Even if it inputs, Update in particular is not carried out. |
| LatestUpdate | Date | | | Reference Item at the time of CSV output 【SaleUnit priceList】. Even if it inputs, Update in particular is not carried out. |
Confirm of SaleUnit priceBatch entry †
- Before Batch entry, it is Confirm(ed) whether there is any error in the contents of a file.
- A Confirm procedure becomes as follows.
①【SaleUnit priceBatch entry 】 is started, One of Batch entry and Batch delete is specified by Register type, the 〔Reference〕 button of File name is click(ed) and the file which uploads is specified.
②If the Confirm button is click(ed), Confirm processing will start.
③Since a List indication of the Confirm result will be given if the 〔Result confirmation 〕 button is click(ed) after processing, Confirm that it is errorless.
Entry of SaleUnit priceBatch entry
- The 〔Entry 〕 button will be click(ed) and there is Batch entry [ with the 〔Confirm 〕 button / SaleUnit priceinformation ] if there is no error in the file [ Batch entry / file ].
- When Customer item is not Entr(ied) by Primary table for customer item change information, It Entr(ies) automatically to Primary table for customer item change information by Customer of a file, and Customer item.
※In the case of a setup (system parameter) treated as Customer item=Plant item
- An Entry procedure becomes as follows.
①【SaleUnit priceBatch entry 】 is started, One of Batch entry and Batch delete is specified by Register type, the 〔Reference〕 button of File name is click(ed) and the file which uploads is specified.
②If the Entry button is click(ed), Batch entry /Delete processing will start.
③Since a List indication of the Entry /Delete result will be given if the 〔Result confirmation 〕 button is click(ed) after processing, Confirm that it is errorless.
※When an error exists, Entry /Delete of SaleUnit priceinformation used as an error is not carried out. Entry /Delete of SaleUnit priceinformation used as an error is carried out.
Result confirmation of SaleUnit priceBatch entry †
- Indicate the result processed with the 〔Confirm 〕 button and the 〔Entry 〕 button by List.
Resuluting output of SaleUnit priceBatch entry †
- Download the contents of List of Result confirmation by All pieces and CSV.
![[PukiWiki]](image/logo.jpg "[PukiWiki]"){kind=logo}
OnlineManual
