Navigation:  Movement Functions >

Customer To Store

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

This movement transaction is performed to perform a shipping correction or the actual return of goods that were previously sold to a customer via the "Stores to Customer" (counter sales) movement.  Credits can also be granted for the return of non-stock sales or for services rendered.

 

The function provides the option to select a pallet ID to return a complete pallet with its full contents. It also provides the option to specify the delivery note number and selectively identify the lines and quantities that are to be returned.

 

Reason codes must be entered for stock sales returns and the function provides the option to quarantine the returned stock. Since the stock is returned, the stock quantities will be up adjusted accordingly.

 

By performing this movement transaction, credit links will be inserted for every delivery note line that was selected for return and the movement transactions will be recorded in the Movement table for all stock sale returns.

 

The customer's predefined credit note and credit link options will govern whether:

 

The credit links are added to the original invoice, new lines and links are to be added to an existing credit note specified by the user, or a new credit note is to be created.

 

Such credit notes will either contain the customer as the organisation code, or its parent organisation, depending on whether the customer performs independent accounting.

 

The Movement and Debtors journals will also be triggered, depending on the current status of the debtor invoice and depending on the fixed account setting for the returned parts and in accordance with the System Configuration setting for the Stock Valuation Method of either "Standard" or "Average Costing".

 

NOTE: The function will not automatically reverse or reduce the bank transaction and settlement amounts of previously settled invoices, since the return does not imply that the customer requires a refund.

 

The user must decide whether any bank transactions must be performed to credit the customer or whether a credit note is to be issued which can be applied for future or replacement purchases by the customer.

 

INQUIRE

The user must have a security profile linked to the function Customer to Stores with an access allowed of Inquire.

 

On this tab the following fields can be viewed:

 

hmtoggle_plus1Add

The  button is enabled when a pallet ID or delivery note number is selected and the user is either the store manager of the selected store or a linked store employee permitted to perform the movement "Customer to Stores" as defined in the Store Employee Access table.

 

When the  button is clicked, the debtor lines links related to the selected delivery note number that have quantities not returned will be populated in the Available Lines for Customer Returns grid.

 

RELATED TOPIC: Store Employee Access

hmtoggle_plus1Apply

The user must have a security profile linked to the function Customer to Stores with an access allowed of Change.

 

The "Apply" button is enabled if the user has the correct security profile and at least one selected record appears in the "Selected Lines for Customer Returns" list box.

 

When the "Apply" button is clicked, the following updates are performed:

 

1.The system validates that a, valid division, customer, location, reason code and store have been selected.  It also validates that one or more line(s) to apply, have been selected.

 

2.The Movement_Stores_To_Cust stored procedure is executed.

 

3.The Number_Control stored procedure is executed to determine the next credit note number where applicable with credit note option 'C'.

 

4.If a pallet was returned the Pallet Instance table is updated for the fields 'Ship To Organisation', 'Date Shipped' and 'Expected Return Date', by setting those values back to spaces and the dates to "1 Jan 1900".

 

5.A movement (from Customer to Store) will be inserted for every stock line returned, recording all the detail that was entered in both the base and alternate units of measure.

 

6.For stock sales, the Update Location stored procedure is executed. The stock (location) quantity on hand value is updated with the stock returned and the movement journal stored procedure is executed (journal counter sales standard OR journal counter sales average, depending on the Stock Valuation Method specified on System Configuration).

 

7.In accordance with the Credit Note Invoice option, debtor invoice credit links will be added to the original invoice, or debtor invoice credit lines and links will be added to a selected, existing credit note, or a new Credit note with lines and links will be added.

 

8.The tax amounts are calculated by applying the tax percentage valid for the original shipping links.

 

9.Note that the bank transaction and settlements of an original  "cash sale" will not be reversed.

 

10.If you are not using the System front end for updates, the following parameters can be passed to the stored procedure:

 

FIELD

 TYPE

@CodeToExecute

 Integer

@IntegerOne

 Integer

@IntegerTwo

 Integer

@TheBit

 Bit

@DecimalOne

 Decimal(4,2)

@DecimalTwo

 Decimal(12,3)

@DecimalThree

 Decimal(13,2)

@DecimalFour

 Decimal(13,2)

@DecimalFive

 Decimal(13,2)

@DecimalSix

 Decimal(13,2)

@DecimalSeven

 Decimal(13,2)

@DecimalEight

 Decimal(16,5)

@DecimalNine

 Decimal(16,5)

@DecimalTen

 Decimal(16,5)

@CharOne

 Char(1)

@CharTwo

 Char(1)

@CharThree

 Char(3)

@VarcharOne

 Varchar(30)

@VarcharTwo

 Varchar(30)

@VarcharThree

 Varchar(30)

@VarcharFour

 Varchar(30)

@VarcharFive

 Varchar(30)

@VarcharSix

 Varchar(30)

@VarcharSeven

 Varchar(50)

@VarcharEight

 Varchar(70)

@VarcharNine

 Varchar(70)

@VarcharTen

 Varchar(70)

@VarcharEleven

 Varchar(70)

@VarcharTwelve

 Varchar(70)

@VarcharThirteen

 Varchar(70)

@VarcharFourteen

 Varchar(255)

 

NOTE:

Every time this stored procedure is executed, all the variables in the stored procedure need to be sent a value.

 

Where variables are Integer, Bit and Decimal data types and no specific value is being passed, a "0" (zero) must be sent.  This must also be sent as a value and the stored procedure must receive the variable without quotes.

 

Where variables are Char and Varchar data types, the values are sent through a string variable.  They therefore require single quotes around the value.  If no value is being sent, a default of "" is passed.

 

Every time the stored procedure is executed, it uses the @CodeToExecute variable. This is used to determine which part of the stored procedure will be executed.  This value must also be sent through as the first parameter every time.

 

11.The original movement "Quantity Returned"  (for stock returns) will be updated in the Movement table with the movement quantity. If you are not using the system front end for updates, the parameters to be passed are selected as follows:

The parameters to be passed to the stored procedure are selected as follows:

@CodeToExecute         = @CodeToExecute (in this case : 1 pointing to the procedure "Update Movement" within the storeprocedure)  

@QuantityReturned                = @DecimalEight

@DateTime                = @VarcharOne

 

@QuantityReturned       Decimal(16,5)   (When selecting Part Numbers: Quantity -Quantity_Returned from the Movement Table.  When selecting Pallet ID's: Select the Linked_Quantity from the Debtor_Line_Link table. Mandatory)

 

@DateTime                     DateTime  (Date_Time from the Movement Table, mandatory)

 

eg.

EXEC  Movement_Store_To_Cust 1,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  2 ,  0 ,  0 ,  '',  '',  '',  'Jul  2 2001 10:01:11:483AM    ',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  0 ,  0

 

12.For a stock sale return, the stock will be returned to the specified store location and will be quarantined if the option was selected.

 

The Update_Location stored procedure is executed. If you are not using the System front end for updates, the following parameters can be passed to the stored procedure:

 

FIELD

 TYPE

Part_Number

 varchar(30) (When selecting Part Numbers, use the Part_Number from the Movement table.  If selecting Pallet ID's, use the Part_Number from the Debtor_Line_Link_Detail table. Mandatory)

Serial_Number

 varchar(30) (When selecting Part Numbers, use the Serial_Number from the Movement Table.  When selecting Pallet ID's, select the Serial_Number from the Pallet_Contents Table. Value may also be ''.Mandatory)

Division_Code

 varchar(4) (Select Division_Code from the Movement Table. Mandatory)

Store_Code

 varchar(4) (Select Store_Code from the Movement Table. Mandatory)

Location

 varchar(20) (Select Location from the Movement Table. Mandatory)

Stock_Status

 char(1)(Select Stock_Status from the Movment Table. Mandatory)

Organisation_Code

 varchar(20)(Organisation_Code from the Movement table.  Mandatory)

 

 

 

 

 

 

Revision

 varchar(5) (Select Revision from the Movement Table)

 

 

CodeToExecute                                              Integer    (In this case: 2 pointing to the 'Update Location' Procedure within the Store Procedure, Mandatory)

 

Quarantine                                                     Integer (When chosing to place the stock in Quarantine, select  1. Default value is 0. Mandatory)

 

QuantityReturnedTwo                                    Decimal(16,5) (When selecting Part_Numbers: (Quantity - Quantity_Returned) on the Movement Table. When selecting Pallet _Id's: Linked_Quantity on the Debtor_Line_Link Table. Mandatory)

 

SystemDateTime                                            DateTime (Select today's date from the database: select convert(char(24), getdate(), 113). Mandatory)

 

UnitCost                                                          Decimal(16,5)  (If the Stock_Valuation_Method on System Configuaration = 'A' then select the Unit_Cost from the Movement Table. If Stock_Valuation_Method = 'S' then: (material_price + labour_price + subcontract_price + overhead_price + fixed_overhead_price + transfer_price) FROM part_financial_year_data. Mandatory)

 

The parameters to be passed to the stored procedure are selected as follows:

 

@Quarantine                = @IntegerOne

@PartNumber                = @VarcharSix

@SerialNumber                = @VarcharSeven

@Division                = @VarcharOne

@Store                = @VarcharTwo

@Location                = @VarcharFour

@StockStatus                = @CharOne

@TempOrganisation                = @VarcharFive

@QuantityReturnedTwo                = @DecimalTen@Revision                = @VarcharThree

@SystemDateTime              = @VarcharEleven

@UnitCost                           = @DecimalEight

 

eg.

EXEC  Movement_Store_To_Cust 2,  0,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  1.865 ,  0,  1 ,  'N',  '',  '',  'L',  'C',  '',  'C',  ' ',  '111000775000 06',  ' ',  '',  '',  '',  '08 Jul 2001 16:48:27:750',  '',  '',  '',  '',  0 ,  0

 

13.The movement record(s) is created i.e. a new record(s) is inserted into the Movement table.  For a normal customer to store movement, the parameters to be inserted are selected as follows:

@CodeToExecute                   = @CodeToExecute

@SystemDateTime                = @VarcharEleven

@PartNumber                = @VarcharFourteen

@SerialNumber                = @VarcharThirteen

@UserID                = @VarcharTen

@DeliveryNoteNumber                = @VarcharSeven

@QuantityReturned                = @DecimalNine

@TempPalletId                = @VarcharTwelve

@ReasonCode                = @VarcharSix

@FinYearCostsFrozenCosts                = @DecimalEight

@Division                = @VarcharTwo

@Store                = @VarcharOne

@Location                = @VarcharNine

@StockStatus                = @CharOne

@TempOrganisation                = @VarcharEight

@Account                = @VarcharFive

@Revision                = @VarcharThree

@Customer                = @VarcharFour

@AlternateUOMQuantityReturned = @DecimalTen

 

CodeToExecute              Integer   (In this case: 3 Pointing to the "Insert into Movement' procedure within the store procedure. Mandatory)

 

SystemDate                    DateTime (Today's Date from the database: select convert(char(24), getdate(), 113). Mandatory)

 

PartNumber                    Varchar(30) (When selecting Part Numbers: Select the Part_Number on the Movement Table.  When selecting Pallet ID's: Select the Part_Number on the Debtor_Line_Link_Detail Table.  Mandatory)

 

SerialNumber                 Varchar(30)  (When selecting Part_Numbers: Select the Serial_Number on the Movement Table.  When selecting Pallet ID's: Select the Serial_Number on the Pallet_Contents Table. Mandatory)

 

UserID                           Varchar(20)  (The user id of the logged on Employee. Mandatory)

 

DeliveryNoteNumber      Varchar(15) (Delivery_Note from Debtor_Line_Link.  Mandatory)

 

QuantityReturned           Decimal(16,5) (If selecting Part Numbers: Quantity - Quantity_Returned on the Movement Table. If selecting Pallet ID's: Linked_Quantity on the Debtor_ Line_Link Table. Mandatory)

 

AlternateUOMQuantityReturned    Decimal (16,5)  (Alternate_UOM_Quantity from the Movement Table. Mandatory)

 

TempPalletID                                  Varchar(30)   (When selecting Pallet ID's: select Pallet_ID from the Pallet_Contents Table.  When selecting Part Numbers: Select Crate from the Movement Table.  Mandatory)

 

ReasonCode                                    Varchar(10) (Select Reason_Code from Movement_Reason_Codes. Mandatory)

 

FinYearCostsFrozenCosts              Decimal(16,5) (Select: (material_price + labour_price + subcontract_price + overhead_price + fixed_overhead_price + transfer_price) FROM part_financial_year_data.  Mandatory)

 

Division                                          Varchar(4) (Select the Division_Code from the Movement Table.  Mandatory)

 

Store                                              Varchar(4) (Select the Store_Code from the Movement Table.  Mandatory)

 

Location                                           Varchar(20) (Select Location from the Movement Table.  Mandatory)

 

StockStatus                                    Char(1) (When selecting Part Numbers: select the Stock_Status from the Movement Table.  When selecting Pallet ID's: Select the Stock Status from the Pallet Contents Table. Mandatory)

 

TempOrganisation                           Varchar(20) (Select the Organisation_Code on the Movement Table.  Mandatory)

 

Account                                          Varchar(10) (Select Account from the Debtor_Line_Link Table.  Mandatory.)

 

Revision                                           Varchar(5) (Select Rivision from the Movement table.  Mandatory)

 

Customer                                        Varchar(10) (Organisation_Code from External_Organisation.  Mandatory)

 

Eg.

EXEC  Movement_Store_To_Cust 3,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  5.274 ,  177,  177 ,  'N',  '',  '',  'C',  'L',  ' ',  '726',  '9040    L',  '100',  'DEL470',  ' ',  'P10',  '0758620',  '09 Jul 2001 10:38:04:560',  'P10',  ' ',  '111000825000 00',  '',  0 ,  5.274

 

14.For an adjustment to quarantine movement, a new record is inserted into the Movement table.  If you are not using the System front end, the parameters used for the insert are selected as follows:

@CodeToExecute                     = @CodeToExecute

@PartNumber                = @VarcharOne

@SerialNumber                = @VarcharTwo

@UserID                = @VarcharThree

@QuantityReturned                = @IntegerOne

@ReasonCode                = @VarcharFour

@FinYearCostsFrozenCosts                = @DecimalEight

@Division                = @VarcharFive

@Store                = @VarcharSix

@Location                = @VarcharSeven

@StockStatus                = @CharOne

@TempOrganisation                = @VarcharEight

@Account                = @VarcharNine

@Revision                = @VarcharTen

 

CodeToExecute                       Integer (In this case: 4 pointing to the 'Insert into movement' procedure within the storeprocedure. Mandatory)

 

PartNumber                            Varchar(30) (When selecting Part Numbers: use Part_Number from the Movement Table.  When selecting Pallet ID's: Select Part_Number from Debtor_Line_Link_Detail Table.  Mandatory)

 

SerialNumber                        Varchar(30) (When selecting Pallet ID's, use the Serial_Number on the Pallet_Contents Table. When selecting Part Numbers, use the Serial_Number on the Movement Table.  Mandatory)

 

UserID                                   Varchar(20) (The User ID of the logged on employee. Mandatory)

 

QuantityReturned                  Integer (When selecting Pallet ID's, use Linked_Quantity on the Debtor_Line_Link table. When selecting Part Numbers, use (Quantity - Quantity_Returned) from the movement table.  Mandatory.)

 

ReasonCode                             Varchar(10) (Select Reason_Code from Movement_Reason_Codes. Mandatory)

 

FinYearCostsFrozenCosts       Decimal(16,5) (Select (material_price + labour_price + subcontract_price + overhead_price + fixed_overhead_price + transfer_price) FROM part_financial_year_data.  Mandatory)

 

Division                                   Varchar(4) (Select the Division_Code from the Movement Table.  Mandatory)

 

Store                                       Varchar(4) (Select the Store_Code from the Movement Table.  Mandatory)

 

Location                                   Varchar(20) (Select Location from the Movement Table.  Mandatory)

 

StockStatus                             Char(1) (Select Stock_Status from the Movement Table. Mandatory)

 

TempOrganisation                     Varchar(20) (Select Organisation_Code from the Movement Table.  Mandatory)

 

Account                                     Varchar(20) (Select Account from the Debtor_Line_Link Table. Mandatory)

 

Revision                                     Varchar(5) (Select Revision from the Movement Table.  Mandatory)

 

15.If the returned part was a fixed account part, the Counter Sales Standard Journal  or Counter Sales Average Journal is be triggered by the movement.

 

16.The Shipping Journal is also triggered due to the customer return.

 

17.For both stock and non-stock lines a debtor line link with type Credit (C)                will be inserted into the Debtor Line Link table, either on the original invoice, or on a new or existing Credit Note type ("C") invoice.  The parameters to be used for the insert are selected as follows:

@CodeToExecute                   = @CodeToExecute

@Customer                = @VarcharOne

@InvoiceNumber                = @VarcharTwo

@LineNumber                = @VarcharThree

@SystemDateTime                = @VarcharFour

@Account                = @VarcharFive

@LinkedQuantity                = @DecimalEight@TotalPrice                = @DecimalThree

@TaxAmount                = @DecimalFour

@LinkedQuantityInvoiced                = @DecimalNine

@TotalPriceInvoiced                = @DecimalSix

@TaxAmountInvoiced                = @DecimalSeven

@SourceInvoiceNr                 = @VarcharSeven

@SourceLineNr                      = @VarcharFifteen

@SourceCaptureDate             = @VarcharSix

@TaxCode                              = @VarcharEight

@DeliveryNote                       = @VarcharNine

@DeliveryNoteLineNumber    = @VarcharEleven

@ShipToOrganisation             = @VarcharTen

 

 

CodeToExecute                           Integer (In this case: 5 - pointing to 'Insert into Debtor_Line_Link' within the store procedure)

 

Customer                                     Varchar(20) (If Independent_Accounting on External_Organisation = 'N', select the Parent_Organisation on the External_Organisation Table, else select the Organisation_Code also on the External_Organisation Table.

 

InvoiceNumber                           Varchar(15)(Select the Invoice_Number on the Debtor_Line_Link table.  Mandatory)

 

LineNumber                                Varchar(10)(If the Column_Value on Column_Values = 'C' where Column_Name = 'Debtor_Credit_Line_Link_Opt', select the max(Line_Number) + 1 from the Debtor_Line Table, else select Line_Number from the Debtor_Line_Link Table.  Mandatory)

 

SystemDateTime                        DateTime (Select today's date from the database: select convert(char(24), getdate(), 113).  Mandatory)

 

Account                                      Varchar(10)(Select Account from Debtor_Line_Link Table.  Mandatory)

 

LinkedQuantity                           Decimal(16,5) (When selecting Pallet ID's, select Linked_Quantity from Debtor_Line_Link. When selecting Part_Numbers, select (Quantity - Quantity_Returned) from the Movement Table.  Mandatory)

 

TotalPrice                                   Decimal(13,2) (

QtyReturned for Part Numbers = (Quantity - Quantity_Returned) from the Movement Table.

QtyReturned for Pallet ID's = Linked_Quantity on the Debtor_Line_Link Table

TotalPrice for both PartNumbers and Pallet ID's: Total_Price on Debtor_Line_Link

LinkedQuantity for both PartNumbers and Pallet ID's: Linked_Quantity on Debtor_Line_Link

TotalPrice = Total_Price on Debtor_Line_Link if the QtyReturned = LinkedQuantity

If the QtyReturned <> LinkedQuanitity then TotalPrice = ((QtyReturned * TotalPrice) / LinkedQuantity).  Mandatory)

 

TaxAmount                                  Decimal(13,2) (

TaxAmount = Tax_Amount on the table Debtor_Line_Link IF the QtyReturned = LinkedQuantity.

If the QtyReturned <> LinkedQuantity then TaxAmount = ((QtyReturned * TaxAmount) / LinkedQuantity).  Mandatory)

 

LinkedQuantityInvoiced              Decimal(16,5) (

NewLinkedQuantityInvoiced = Linked_Quantity_Invoiced on the Debtor_Line_Link Table

NewLinkedQuantity = Linked_Quantity on the Debtor_Line_Link Table

i.e. LinkedQuantityInvoiced = (QtyReturned * NewLinkedQuanitityInvoiced) / NewLinkedQuantity.  Mandatory)

 

TotalPriceInvoiced                        Decimal(13,2)(

TotalPriceInvoiced = Total_Price_Invoiced on the Debtor_Line_Link Table if the QtyReturned = LinkedQuantity.

If the QtyReturned <> LinkedQuantity then TotalPriceInvoiced = ((QtyReturned * TotalPriceInvoiced) / LinkedQuantity). Mandatory)

 

TaxAmountInvoiced                       Decimal(13,2)(

TaxAmountInvoiced = Tax_Amount_Invoiced on the table Debtor_Line_Link Table if the QtyReturned = LinkedQuantity.

If the QtyReturned <> LinkedQuantity then TaxAmountInvoiced = ((QtyReturned * TaxAmountInvoiced) / LinkedQuantity) Mandatory)

 

TaxCode                                        Varchar(6) (Select Tax_Code from the table Debtor_Line_Link.  Mandatory)

 

ShipToOrganisation                        Varchar(20) (Select Ship_To_Organisation from the table Debtor_Line_Link.  Mandatory)

 

DeliveryNote                                  Varchar(15) (Select Delivery_Note from the Debtor_Line_Link Table. Mandatory)

 

DeliveryNoteLineNumber               Varchar(10)(Select Delivery_Note_Line_Number from the table Debtor_Line_Link.  Mandatory)

 

SourceInvoiceNumber                    Varchar(15) (Select Invoice_Number from the Debtor_Line_Link Table.  Mandatory)

 

SourceLineNumber                         Varchar(15)(Select Line_Number from the Debtor_Line_Link Table.  Mandatory)

 

SourceCaptureDte                          Varchar(30) (Select Date_Time from the Movement Table. Mandatory)

 

Eg.

EXEC  Movement_Store_To_Cust 5,  177,  0 ,  0 ,  0 ,  0 ,  1426.22 ,  0.00 ,  0 ,  1426.22 ,  0.00 ,  177.00 ,  177.00 ,  0 ,  '',  '',  '',  '',  'AW734',  '3',  '09 Jul 2001 10:38:04:560',  '9040    L',  'Apr  5 2001  6:03:01:100PM    ',  'AW734',  '03',  'DEL470',  '726',  '3',  '',  '',  '',  '3',  0 ,  0

The insert of a debtor line link will trigger the Debtors Journal and the Over The Counter Cost of Sales Journal.

 

18.If the returned line was part of the contents of a pallet, the Pallet Contents table will be updated to reduce the contents to the effect of the returned goods.  The parameters to be used for the insert are selected as follows:

 

@CodeToExecute         = @CodeToExecute

@QuantityReturned                = @IntegerOne

@TempPalletId                = @VarcharOne

@PartNumber                = @VarcharTwo

 

CodeToExecute               Integer(In this case: 6 pointing to the 'Update Pallet_contents' within the store procedure. Mandatory)

 

QuanitityReturned         Integer (Select Linked_Quantity from the Debtor_Line_Link Table.  Mandatory)

 

PalletID                        Varchar(30)(Select Pallet_Id from the Pallet_Contents Table.  Mandatory)

 

PartNumber                   Varchar(30)(Select Part_Number from the Debtor_Line_Link_Detail table.  Mandatory)

 

 

19.If the part selected is part of a pallet, the division code, store code and location on the Pallet Contents table is updated. The parameters to be used for the update are selected as follows:

 

@CodeToExecute     = @CodeToExecute

@Division                = @VarcharOne

@Store                = @VarcharTwo

@Location                = @VarcharThree

@TempPalletId                = @VarcharFour

@PartNumber                = @VarcharFive

 

CodeToExecute                   Integer(In this case: 7 pointing to 'update Pallet_Contents set Division_Code' within the store procedure. Mandatory)

 

Division                                Varchar(4)(Select the Division_Code from the Movement Table.  Mandatory)

 

Store                                   Varchar(4)(Select Store_Code from the Movement Table.  Mandatory)

 

Location                               Varchar(20) (Select Location from the Movement Table. Mandatory)

 

TempPalletID                       Varchar(30) (Select Pallet_ID from the Pallet_Contents Table.  Mandatory)

 

PartNumber                          Varchar(30)(Select Part_Number from the Debtor_Line_Link_Detail Table.  Mandatory)

 

Eg.

EXEC  Movement_Store_To_Cust 7,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  '',  '',  '',  'L',  'C',  'P10',  'P10',  '111000825000 00',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  0 ,  0

 

20.If a complete pallet was returned, the pallet contents will remain the same, but the Pallet Instance table will be updated to remove the "Ship to Organisation", "Date Shipped" and "Expected Return Date" since the pallet is returned to stock and no longer in the category of shipped pallets.

 

The parameter to be used for the update is selected as follows:

 

@CodeToExecute   = @CodeToExecute

@TempPalletId8 = @VarcharOne.

 

CodeToExecute                     Integer(In this case: 8 pointing to the 'Update Pallet_Instance' procedure within the store  procedure.  Mandatory)

 

TempPalletID                         Varchar(30)(Select Pallet_ID from the Pallet_Contents Table.  Mandatory)

 

Eg.

EXEC  Movement_Store_To_Cust 8,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  '',  '',  '',  'P10',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  '',  0 ,  0

hmtoggle_plus1Available Lines for Customer Returns

This grid displays the debtor line links that relate to the specified delivery note number. It therefore displays all delivery note line numbers from the Debtor Line Link table where the delivery note matches the selected delivery note and quantity of the shipping link exceeds the summed quantity of related credit links. (I.E. The quantity shipped is greater than the quantity returned).

 

If a delivery note number was selected, the user can manually select the lines to be returned and adjust the quantities as deemed necessary.  If a pallet ID has been selected, all the lines must be selected and the full quantity shipped must be returned, therefore returning the complete pallet and its total contents.

 

The grid displays the following values:

 

SELECT

The select button is clicked to select the lines to be returned. Once a row has been selected in the grid, the fields in the grid will be enabled to specify the return quantity, the store and location it needs to be returned to, whether to quarantine the stock and the reason for the return.

 

In the scenario where a pallet ID has been selected, all the lines must be selected and the full quantity shipped must be returned, thus returning the complete pallet and its total contents. The user can therefore not be selective and cannot return portions of the pallet contents. The user can specify the reason for the return, the store and location it needs to be returned to and will be permitted to apply the quarantine option.

 

DN LINE

This read only field displays the delivery note line number of the selected Delivery note from the Debtor Line Link table.

 

PART NUMBER

This read only field displays the part number from the Debtor Line Link Detail table. The field will only contain a part number if the debtor line link resulted from a stock sale.  Non-stock sales will not display a value in this field.

 

DESCRIPTION

This read only field displays the description of the sale from the Debtor Line Link Detail table. If the debtor line link resulted from a stock sale, the description will be that of the part that was shipped.  Non-stock sales will display the description as entered at the time of sale.

 

AVAILABLE QUANTITY TO RETURN

This read only field displays the quantity that can still be returned. If no returns have taken place to date, the quantity will still be equal to the original ship quantity.  If the return is for a stock sale, the quantity in this field is expressed in the unit of measure displayed in the UOM field.

 

UOM

This read only field displays the unit of measure in which all quantities are, expressed for the row in the grid.

 

QUANTITY RETURNED

This field is applied to specify the quantity returned by the Customer.  The quantity returned must have a value greater zero but not more than the value displayed for "Available Quantity to Return".  The function by default suggests the full quantity available to return, but the user can change the quantity to a lesser value.

 

Decimal quantities will only be permitted if the part allows decimal movements or, where the row is for a non-stock sale, if the unit of measure allows decimal movements.

 

Take note that if a pallet ID has been selected, the full quantity shipped must be returned, thus returning the complete pallet and its total contents.

 

STORE

This field applies to the return of stock sales.  It specifies the store to which the parts are to be returned.  When an available line is selected, the store is defaulted to the store from which the sale was originally performed (as recorded on the Movement table).

 

The function will permit the user to return the parts to another store.

 

NOTE: If a pallet ID has been selected for return, another store can also be selected but all the lines must be returned to the same specified store and location, since the complete pallet with its total contents is returned.

 

The field is populated with stores from the Stores table.  Only stores that the signed on user is linked to as a store employee, permitted to perform the movement "Customer to Stores" as well as stores, of which the signed on employee is the Store Manager, will be shown.

 

Stores that are In Transit stores will be excluded.  To aid the user, the store description and the division to which the store belongs, is also displayed in the list.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory when stock is to be quarantined).

 

REASON CODE

This field is applied to specify the reason for the customer return.   The field is mandatory for the return of stock sales and optional for the return of non-stock sales. The reason code will be saved in the Movement table for stock sale returns.

 

The list is populated with reason codes and code descriptions from the Movement Reason Codes table where the reason code is permitted for customer return transactions. However, if the "Quarantine" option has been selected, the list is populated with reason codes that are permitted for quarantine.

 

NOTE: If a pallet ID has been selected for return, the same reason code must be selected for all the lines, since the complete pallet with its total contents is returned.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".  This field is mandatory if stocked items are returned and optional if non-stocked items are returned.

 

QUARANTINE

This option applies to stock sales that are returned.  When checked, it indicates that the stock being returned must be received into the store as quarantine stock.   The function will automatically perform a return movement as well as a transfer movement to quarantine the stock.

 

If the quarantine option is checked, the list is for reason codes is populated with reason codes that are permitted for quarantine. See Reason Code for more detail.

 

LOCATION

This field applies to the return of stock sales.  It specifies the location in the store to which the parts are to be returned.  When an available line is selected, the "Location" is defaulted to the location from which the sale was originally performed (as recorded in the Movement table).

 

The function will permit the user to return the parts to another location.

 

NOTE: If a pallet ID has been selected for return, another location can also be selected but all the lines must be returned to the same specified store and location, since the complete pallet with its total contents is returned.

 

If a location is typed, the function will enforce that the location format (if predefined for the store) is typed in accordance with the specified format(s).

 

SALES PRICE

This read only field serves as an aid by displaying the sales unit price for the original shipping transaction and related debtor line and link.

 

STOCK STATUS

This read only field serves as an aid for stock sale returns by displaying the stock status of the stock as recorded in the Movement table at the time the sale was originally made. Returned parts will assume the same status in the Location table when the return transaction is performed.

 

REVISION

This read only field serves as an aid for stock sale returns by displaying the revision number of the stock as recorded in the Movement table at the time the sale was originally made. Returned parts will assume the same revision number in the Location table when the return transaction is performed.

 

ORIGINAL DN QUANTITY

This read only field serves as an aid by displaying the quantity originally shipped in the sales unit of measure for the delivery note line displayed in the grid row.

 

SERIAL NUMBER

This read only field serves as an aid for stock sale returns for serialised parts by displaying the serial number of the part as recorded in the Movement table at the time the sale was originally made. Returned parts will assume the same serial number in the Location table when the return transaction is performed.

 

DIVISION

This read only field displays the division code from the Movement table and thus displays the division that performed the stock sale for the original sales transaction.

 

PALLET ID

This read only field displays the pallet ID if a stocked part was sold as part of a pallet's contents.

hmtoggle_plus1Calculate Tax

Clicking of this button calculates the applicable Tax Amount for all selected rows. The button only enables if Tax needs to be calculated via a 3rd party tax interface system such as Taxware or Vertex. Where tax is calculated via predefined tax codes and percentages, the button need not be clicked.

hmtoggle_plus1Created By

This read only field serves as an aid by displaying the name and employee ID of the user that performed the original sales transaction.

 

The "created by" is read from the Debtor Invoice Status History table by applying the employee responsible for the oldest status history record for status "Created".

 

This is done once a valid Delivery Note Number or Pallet ID is selected.

hmtoggle_plus1Credit Amount (Excl Tax)

It is a read only field that dynamically displays the running credit total (excluding tax) as calculated for the selected lines and returned quantities in the grid Available Lines for Customer Returns.

hmtoggle_plus1Credit Link

The credit link option takes preference over the credit note option.

It displays the credit link option as applicable to and defined for the Customer on its External Organisation record and cannot be set to another value via this function.

 

For the counter sales movements, option "L" is applied and to specify that a credit link and credit link must be added to the original invoice.

 

If option "L" applies, a new line and link will be inserted on the original invoice that carries the shipping link.

 

Even though the screen may display option "L", it will be ignored if the original invoice has already been "Print Approved" or "Printed" and the method applied by option "C" (Add a credit link to Credit notes) will

be executed.

 

It is only for credit link option "C" where the Credit Note option is taken into consideration. For other options the Credit Note option is ignored.

hmtoggle_plus1Credit Link/Credit Note Option

This frame displays the credit link and credit note options as applicable to and defined for the Customer on its External Organisation record.

 

If the Credit Note option specifies that credit links are to be added to an existing credit note, the user must specify the credit note by selecting a credit note number in the Credit note invoice number field.

hmtoggle_plus1Credit Note

It is only for credit link option "C" where the credit note option is taken into consideration. For other options the Credit note option is ignored.

 

If the credit link option is "C" (Add a credit link to credit notes), the credit note option governs whether a new Credit note is to be created (option "N") or whether a credit line and link must be added to an existing credit note that has not yet been "Print Approved" or "Printed"".

 

Option "N" will create a new credit note and apply the next credit note number from Number Control on the System Configuration function.

 

Option "B" requires a credit line and link to be added to an existing credit note, which requires the selection of the applicable credit note number in the Credit Note Invoice Number field.

 

If the user fails to select an existing credit note number (whether by neglect or due to the fact that no credit notes with the correct status currently exists for the Customer), a new credit note will be created as if the option was set to "N".

hmtoggle_plus1Credit Note Invoice Number

This field is selected whenever the Credit Note option is "B", which requires a credit line and link to be added to an existing credit note.

 

A number of settings for the customer govern, which credit notes will be populated for selection. The settings are:

 

On Hold Link Enforce New Document

This setting governs whether links can be added to a credit note that already has one or more links that have been placed on hold (If set to "No", only credit notes without "on hold" links will be displayed for selection).

 

Independent Accounting

This setting governs whether the customer performs independent accounting and can therefore be billed or credited.

 

If set to "Yes" credit notes for the selected customer will be displayed for selection. If set to "No", the customer's parent organisation is the one to be billed or credited and therefore credit notes of the customer's parent organisation, where the customer appears as the "Ship To Organisation", will be displayed for selection.

 

If the user fails to select an existing credit note number (whether by neglect or due to the fact that no credit notes with the correct status currently exists for the Customer), a new credit note will be created as if the option was set to "N".

hmtoggle_plus1Credit Tax Amount

It is a read only field that displays the running total credit tax amount as calculated  for all selected lines in the Available Lines for Customer Returns grid.

hmtoggle_plus1Customer

This field is applied to specify the name of the Customer returning the goods or services rendered.

 

The selection of the customer name will therefore govern which delivery notes will be displayed for selection, since only delivery notes of the selected customer will appear in the list of invoices.

 

The list is populated with the external organisation names, codes and debtors trading status from the External Organisation table where the External Organisation has an active debtor control account code that identifies the Organisation as a customer.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

hmtoggle_plus1Date Created

This read only field serves as an aid by displaying the date that the invoice was created, therefore also representing the date that the original sale was performed.

 

The creation date is read from the Debtor Invoice Status History table by applying the status change date for status "Created".

 

This is done once a valid Delivery Note Number or Pallet ID is selected.

hmtoggle_plus1Delivery Address

This read only field serves as an aid by displaying the delivery address as recorded on the selected Invoice at the time the sale was originally made.

 

The delivery address is read from Delivery Address Lines 1 - 5on the Debtor Invoice table once a valid Invoice Number or Pallet ID is selected.

hmtoggle_plus1Delivery Note Number

This field is applied to specify the delivery note number against which the goods or services to be returned were originally shipped. The field is only enabled if the mode Pallet Utilised for Movement has not been selected.

 

In this mode, the delivery note and invoice number will be automatically defaulted once the Pallet ID has been selected. It is of no use to type the number prior to selecting the Customer name, as only delivery notes of the selected customer will appear in the list for selection.

 

The list displays distinct delivery note numbers from the Debtor Invoice Line Link table where:

 

The "Ship To Organisation" matches the organisation code of the selected Customer, The invoice debtor line link record(s) has a sales account belonging to the selected Division and, the invoice debtor line link record(s) do not have a referenced customer order number, thus being a counter sale invoice.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".

hmtoggle_plus1Division

This mandatory field is used to identify the division within your company that was responsible for the execution of the original shipping transaction Stores to Customer and was therefore also the division that was credited with the sale.

 

Since the function is applied to return/reverse the sale or a portion thereof, the same sales account and tax sales account of the Division originally credited, will be debited by this transaction.

 

The selection of the Division will therefore govern which delivery notes will be displayed for selection, since only delivery notes from invoices containing the sales account of the selected Division will appear in the list of selectable delivery note numbers.

 

The Division list is populated with the division code and the description from the Division table where the division has a valid "Over the Counter Sales" account as well as a valid "default bank for counter sales".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

 

RELATED TOPIC: Default Bank For Counter Sales on Division

hmtoggle_plus1Invoice Number

This read only field displays the invoice number associated with the selected delivery note number or specified pallet ID.

 

The number may be the same or differ from the delivery note number depending on the Customer's predefined debtor invoice/delivery note options as specified on External Organisation

 

The invoice organisation will either be the Customer or, where the customer's "Independent Accounting" setting was set to "N" (no), the invoice organisation will be the Customer's parent organisation.

hmtoggle_plus1Pallet Id

This field is enabled when the Pallet Utilised For Movement check box is checked.

Selecting a pallet ID specifies that a complete pallet with its full contents is to be returned.

 

In this mode the Invoice number is disabled. The user must specify the Pallet ID, which will automatically default the Invoice number once the pallet ID has been selected and populate the grid with the invoice lines. The user will not be able to select only certain lines, since all lines (making up the pallet contents) must be returned simultaneously.

 

The list is populated with pallet ID's that have been shipped to the selected Customer and where the resulting invoices contain sales accounts belonging to the selected Division.

 

When the pallet ID is typed, the function accesses the tables Movement, Pallet Contents and Debtor Line Link to display pallets where:

 

The pallet ID exists in the Movement table as the crate number, the crate (pallet ID) on the Movement table exists on the Pallet Contents table.

The invoice number on the Debtor Line Link table is equal to the delivery note on the Movement table,

The invoice contains debtor line links that are Shipping "S" links, and the shipping links have not yet been fully returned, and the sales account on the debtor line link belongs to the selected Division.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".

hmtoggle_plus1Pallet Utilised for Movement

By checking this mode, the user specifies that a complete pallet with its full contents is to be returned.  If only a portion of the pallet contents is to be returned, do not select this mode but rather select the invoice and then specify the lines and quantities to be returned.

 

In this mode the Invoice number is disabled. The user must specify the Pallet ID, which will automatically default the Invoice number once the pallet ID has been selected and populate the grid with the invoice lines.

hmtoggle_plus1Recipient Name

This read only field serves as an aid by displaying the name of the recipient as recorded on the invoice of the selected delivery note at the time the sale was originally made.

 

The recipient name is read from the Debtor Invoice table (contact person) once a valid Invoice Number or Pallet ID  is selected.

hmtoggle_plus1Recipient Telephone Number

This read only field serves as an aid by displaying the telephone number of the recipient as recorded on the invoice of the selected delivery note at the time the sale was originally made.

 

The recipient telephone number is read from the field contact telephone number on the Debtor Invoice table once a valid Invoice Number or Pallet ID is selected.

hmtoggle_plus1Remove

When the  button is clicked, all the lines in the grid and the Credit Amount values are cleared.

hmtoggle_plus1Return Advice Number

This is the return advice number for goods returned to you by your customer.  It is optional for an invoice in Created status.

It is mandatory for an invoice in Print Approved or Printed/Confirmed status.

 

If a return advice has been specified, credit links will be created on either the original invoice or on a credit note, depending on the customer's credit link and credit note options.

 

If no return advice has been specified, the quantity and amounts of the original shipping link on the invoice will be down adjusted in accordance with the quantity and associated amount returned.

This implies that an actual customer return is not involved, but that the user is performing shipping corrections where the wrong part or quantity was shipped.

hmtoggle_plus1Shipped Since

This date governs which delivery notes and lines will be displayed in the Available Lines list box to be selected for returns or corrections.

The date defaults to 20 working days into the past, thus normally resulting in the display of shipping transactions for the past month.  

 

Only delivery note lines with a capture date (date shipped) later than the specified "Shipped Since" date will be displayed.

If the actual shipping took place earlier, set the date back to an earlier date in which case the delivery note will be displayed for selection.

hmtoggle_plus1Status

This read only field serves as an aid by displaying the current status of the Invoice.  The statuses can include "Created", "Print Approved", "Not Print Approved" or "Printed".

 

The status is read from the Debtor Invoice table once a valid Delivery Note Number or Pallet ID is selected.

hmtoggle_plus1Total Credit Amount

It is a read only field that dynamically displays the running credit total (including tax) as calculated for the selected lines and the returned quantities in the Available Lines for Customer Returns grid.