Bug 2870 - E-INVOICING to be implemented before 1-APR-2020
Summary: E-INVOICING to be implemented before 1-APR-2020
Status: RESOLVED DUPLICATE of bug 3218
Alias: None
Product: IMIS SALES
Classification: 01.IMIS
Component: IMIS SALES FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: All All
: Normal normal
Assignee: Mahender
URL:
Depends on:
Blocks:
 
Reported: 2020-01-31 19:02 IST by kk
Modified: 2020-03-06 12:32 IST (History)
1 user (show)

See Also:
Database:
Module ID:

Attachments
e-invoice schema (43.42 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-01-31 19:02 IST, kk 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Comment 6 Mahender 2020-03-06 12:32:47 IST 
DUPLICATE CALL

*** This bug has been marked as a duplicate of bug 3218 ***
Comment 3 Mahender 2020-02-04 13:13:21 IST 
{
"Sale_Invoice":{
"SI_RECID":20000005797050
,"COMPANY":"24"
,"INVOICE_DATE":"2020-02-03T00:00:00Z"
,"INVOICE_TYPE":"I1"
,"INVOICE_SERIES":"TI19"
,"INVOICE_NO":4926
,"Invoice_items":[
{
"ITEM_CODE":"FBPICCCP468G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FBPICCCP468G"
,"ITEM_NAME":"PICOLO COFFEE CANDY PET JAR  (3.6GM X 130) - PROMO SCHEME"
,"NET_PRICE":85.56
,"NO_OF_PACKS":320
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":130
,"INVOICE_VALUE":29278
}
,{
"ITEM_CODE":"FKFASCYJ1K69"
,"STOCK_TYPE":"003"
,"ITEM_CODE":"FKFASCYJ1K69"
,"ITEM_NAME":"FRU KIK ASSORTED JUMBO JAR 3.2 GM (1 jar=530 candy)"
,"NET_PRICE":349.11
,"NO_OF_PACKS":42
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":530
,"INVOICE_VALUE":13093.16
}
,{
"ITEM_CODE":"FMFASJLJ1924"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FMFASJLJ1924"
,"ITEM_NAME":"FRU JELLY ASSORTED JUMBO JAR (3.6gm X 520) - GW"
,"NET_PRICE":342.51
,"NO_OF_PACKS":90
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":520
,"INVOICE_VALUE":27767.34
}
,{
"ITEM_CODE":"FMFASJLP18GM"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FMFASJLP18GM"
,"ITEM_NAME":"ASSORTED FRU POUCH 18G (5 JELLY) - TOY PROMO"
,"NET_PRICE":3.29
,"NO_OF_PACKS":9680
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":5
,"INVOICE_VALUE":31470.53
}
,{
"ITEM_CODE":"FMFGVJLJ740G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FMFGVJLJ740G"
,"ITEM_NAME":"FRU GUAVA JELLY PET JAR (3.6gm X 200) - GW"
,"NET_PRICE":131.69
,"NO_OF_PACKS":48
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":200
,"INVOICE_VALUE":6162.28
}
,{
"ITEM_CODE":"FMFSWJLJ740G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FMFSWJLJ740G"
,"ITEM_NAME":"FRU STRAWBERRY JELLY PET JAR (3.6gm X 200) - GW"
,"NET_PRICE":131.69
,"NO_OF_PACKS":72
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":200
,"INVOICE_VALUE":9243.44
}
,{
"ITEM_CODE":"FRFASCYJ2k16"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FRFASCYJ2k16"
,"ITEM_NAME":"FRU RUS ASSORTED JUMBO JAR (01 JAR = 900 CANDY, 01 CANDY = 2.4 GM)"
,"NET_PRICE":296.37
,"NO_OF_PACKS":54
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":450
,"INVOICE_VALUE":14897.18
}
,{
"ITEM_CODE":"FRFKACYJ720G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FRFKACYJ720G"
,"ITEM_NAME":"FRU RUS KACCHA AAM FLAVOURED CANDY(01 JAR = 300 CANDY, 01 CANDY = 2.4 GM)"
,"NET_PRICE":98.8
,"NO_OF_PACKS":48
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":150
,"INVOICE_VALUE":4414.28
}
,{
"ITEM_CODE":"FRFLECYJ720G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FRFLECYJ720G"
,"ITEM_NAME":"FRU RUS LEMON FLAVOURED CANDY (01 JAR = 300 CANDY, 01 CANDY = 2.4 GM)"
,"NET_PRICE":98.8
,"NO_OF_PACKS":16
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":150
,"INVOICE_VALUE":1471.43
}
,{
"ITEM_CODE":"FRFORCYJ720G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FRFORCYJ720G"
,"ITEM_NAME":"FRU RUS ORANGE FLAVOURED CANDY(01 JAR = 300 CANDY, 01 CANDY = 2.4 GM)"
,"NET_PRICE":98.8
,"NO_OF_PACKS":80
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":150
,"INVOICE_VALUE":7357.12
}
]
}
,"metadata":{
"published_date":"04-FEB-2020"
,"publisher":"oracle-base.com"
}
}
Description kk 2020-01-31 19:02:43 IST 
Created attachment 725 [details]
e-invoice schema

see attached schema file. we need to discuss this in detail and start work on this.