Main Menu > Settings > Import & Export > Import Link Setting (T > I > P)
Need to upload Sale and Stock Report on SFTP site
Scenario:
Need to generate sale bill cum product wise detail and Stock report file in xml format for all locations in a single file of LG brand. Upload on the SFTP site provided by LG on a daily basis on schedule time.
Solution:
In Process Scheduler (T-M-P) - add two fields in detail
●Brand(s): Choose a list of the Brand name.
●Settings JSON: Need to add the file of Upload Path while adding the process schedule.
(In case of SFTP or FTPS site save the credentials here in JSON format )
Sample:
{"TPCode": "vwhVfj", "URL": "https://info.payu.in/merchant/postservice.php?form=2"} [^]
In Process List - add two options
●LG Sellout Report
●LG Stock Report
Note:
1.For HO location, these two reports will be generated for all location combined i.e. a single XML file for all locations
Find the mapping of the field in the below link:
https://docs.google.com/spreadsheets/d/1bT1jVOGxVoN-YMt3DZKdzisrrDVUJczmPCokkoSw5No/edit#gid=0 [^]
2.For GTM-Code, need to use Location Mater UDF1.
Request changes in SAGE 50 export data
In Location Export Setting (T-I-P) - Under Export Setting of Sergeant Major
Added two new fields
Accounts Payable Code (Sage) = Text
Show the code entered here, in Account Payable account column of Sage 50 - Purchase Report.
Accounts Receivable Code (Sage) = Text
Show the code entered here, in Account Receivable account column of Sage 50 - sale Report.
Need to Export Sale and Purchase data to Sage 50
Scenario:
Need to Export Sale and Purchase accounting data for Sage 50(third party) in CSV format.
Solution:
In Location Export Setting (TIP), added two options in Type List.
●Sage 50 - Purchase
●Sage 50 - Sale
Based on this option, a required file in CSV format will be generated.
Require to export Cash sheet for ledger group other than Cash.
Scenario:
We export SAP Cash Sheet data into an excel sheet by option only for the transaction (Sale, Purchase & Finance Voucher) done for Cash A/c.
But now we also want to export expense voucher data (entered with this new a/c) into excel sheet separately and existing Cash A/c data export should remain as it is.
Solution:
In Location Export Setting (T>I>P) - Under Export "Settings for Cash Sheet"
an option is added
"Groups for Cash Sheet = Blank / Multi Selection List".
If it is blank, then it will consider the Cash Group by default.
If multiple groups are selected in the above field, then separate sheets will be generated for each group.
Need to generate Consolidated Purchase Requisition in Excel from Purchase Order Entry
Scenario: You might want to export the consolidated purchase order to SAP as purchase requisition in excel format.
Solution:
In Location Export Settings (T>I>P),
Added a new section "Export Settings for PR and GRN (SAP)" and following fields
●Plant Code
●Purchase Organization
●Location Name = Multi selection list
●Create File on Day Close (Purchase Requisition) = No / Yes
●Create File on Day Close (Purchase GRN) = No / Yes
In List Type added following options
●SAP - PR: Generate a report in excel for purchase order of given date range for selected locations in a single sheet as per the shared format
●SAP - GRN: Generate a report in excel for purchase invoice of given date range for selected locations in a single sheet as per the shared format.
Notes:
●Exclude bills which do not have SAP PO number (recorded in UDF10)
●This activity needs to be done only HO location.
Enhancement in Location Export Setting (SAP-GST) to Exclude Sale of Particular MOP
Scenario
It is required to exclude the sale of certain mode of payment during the export of sale for SAP-GST in xml format.
Solution
We have added an option In Location Export Setting (T>I>P),
●Under Export setting SAP "Exclude MOP = Multi Selection List of MOP "
Generation of XML file to export sales (with GST) in SAP
In Location Export Settings (TIP) -
●Added "SAP - GST" in Type List
●Added a button "Map Product" (Atrl+M)
○ It will open a screen with Product Name and an input field to enter MAP CODE (SAP)
In Product Master (MIP) - In Other Information
●Added a field Map Code (SAP)
Added “SAP Non Cash Sheet” in Location Export
In T I P (Export Setting for Cash Sheet), we have added an option SAP - Non Cash Sheet. Based on this option all sale data except cash sale will be exported in excel sheet
Profit Center instead of Cost Center in export to SAP - Non Cash Sheet
In Export Location Setting (T>I>P) > SAP - Non Cash Sheet, following changes has been done
Under Export setting for Cash Sheet, added a field Profit Center.
In SAP - Non Cash Sheet Profit Center field will be shown instead of Cost Center
Note: Except Credit Sale, for all other MOP like credit card, sodexo etc, data will be exported to excel as per day wise summary for each MOP as per accounting ledger attached will be exported to excel .
For example ,if there are 2 credit card MOP say HDFC Bank and AXIS Bank with
respective accounting ledger attached, in this case single row of day summary for each credit card will be exported to excel
SAP integration for cash related transactions.
This module creates an SAP ready excel file for each day id or based on date range provided by the user. You need to configure the settings in Location Export settings (T>I>P).
