AQL052 のバックアップ(No.9)

バックアップ一覧
差分を表示
現在との差分を表示
ソースを表示
AQL052 へ行く。
- 1 (2011-07-26 (火) 20:18:09)
- 2 (2011-07-27 (水) 19:08:00)
- 3 (2011-10-25 (火) 20:27:56)
- 4 (2012-01-13 (金) 17:59:33)
- 5 (2012-06-16 (土) 11:53:05)
- 6 (2012-06-27 (水) 11:33:46)
- 7 (2012-06-29 (金) 21:15:11)
- 8 (2012-07-02 (月) 15:11:38)
- 9 (2012-07-02 (月) 19:48:48)

Sales unit price batch entry †

Order control
- Sales unit price batch entry

Sales unit priceinformation managed at its company is edited in Excel (CSV), the Sales unitpriceinformation is summarized on a number screen and Read-in sees it. Since the file [ CSV output / file / 【Sales unit price list】 ] 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 【Sales unit price list】. Even if it inputs, Update in particular is not carried out.Quantity unit of Order quantity.
Sales unit price	number	16,4	○	Sales unit price is inputted by larger value than zero.
Currency		-		Reference Item at the time of CSV output 【Sales unit price list】. Even if it inputs, Update in particular is not carried out. Currency of Sales unit 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 Sales unit price is inputted. Time can also be No.t inputted.
Expire date		-		Reference Item at the time of CSV output 【Sales unit price list】 . 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 【Sales unit price list】. 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 【Sales unit price list】. It is used for automatic Entry of Primary table for customer item change information.
Plant	Character			Reference Item at the time of CSV output 【Sales unit price list】. Even if it inputs, Update in particular is not carried out.
LatestUpdate person	Character			Reference Item at the time of CSV output 【Sales unit price list】. Even if it inputs, Update in particular is not carried out.
LatestUpdate	Date			Reference Item at the time of CSV output 【Sales unit price list】. Even if it inputs, Update in particular is not carried out.

↑

Confirm of Sales unit price batch 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.
①【Sales unit price batch 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 Sales unit price batch entry †

The 〔Entry 〕 button will be click(ed) and there is Batch entry [ with the 〔Confirm 〕 button / Sales unit 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.
①【Sales unit price batch 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 Sales unit priceinformation used as an error is not carried out. Entry /Delete of Sales unit priceinformation used as an error is carried out.

↑

Result confirmation of Sales unit price batch entry †

Indicate the result processed with the 〔Confirm 〕 button and the 〔Entry 〕 button by List.

↑

Resuluting output of Sales unit price batch entry †

Download the contents of List of Result confirmation by All pieces and CSV.