10 thoughts on “Invoice Customisation VIII : Poonam Corporation”
Hello Sir I am Unable to fetch Date and Voucher Item
[#Form: Sales Color]
;; Background : Yellow
Delete: Print : Printed Invoice
Add: Print : InvPrint1
[Report: InvPrint1]
Form: InvPrint1
[Form: InvPrint1]
Part:InvPrint1,CmpStatDetPart1,Itempart1
[Part: InvPrint1]
Line: InvPrint1,CmpAdd1
Border: Thin Bottom
[Line: InvPrint1]
Field: Name Field
Local: Field: Name Field: Set as: @@CmpMailName;;: Company: ##SVCurrentCompany
Local: Field: Name Field: Align:Center
Local: Field: Name Field: Style: Large Bold
Local: Field: Name Field: Full Width: Yes
Height: 2
Indent: 25
[Line: CmpAdd1]
Field: Name Field
Local: Field: Name Field: Set as: @@CmpAddress
Local: Field: Name Field: Align: Center
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style: Large Bold
[Part: CmpStatDetPart1]
Parts: CmpLeft,CmpMiddle
Right Part: CmpRightPart
;;Common Border:Yes ;; for perfect alignment
Border: Thin Box
Height:7
[Part: CmpLeft]
Line: MyLine1
Border: Thin Right
Common Border: Yes
[line: Myline1]
Field: Name Field
Local: Field: Name Field: Set as: “Left”
Local: Field: Name Field: Style: Arial
[Part: CmpMiddle]
Line: MidLine1
Border: Thin Right
Common Border: Yes
[Line: MidLine1]
Field: Name Field
Local: Field: Name Field: Set as: “Middle”
Local: Field: Name Field: Style: Arial
[Part: CmpRightPart]
Line: Invno,InvDate
Border:Thin Right
Common Border: Yes
[Line: Invno]
Field: Name Field,Invno
Local: Field: Name Field: Set as: “INVOICE No.”
Local: Field: Name Field: Style: Arial
[Field: Invno]
Use: Number Field
Set as:$VoucherNumber
[Line: InvDate]
Field: Name Field,Dtfld1
Local: Field: Name Field: Set as: “Date:”
Local: Field: Name Field: Style: Arial
Hello Ankit,
There are mistakes in your code and it doesn’t match with the course chapter.
Please compare every line of your code with the course chapter. You are skipping something and I want you to find out yourself what you are skipping.
Even if it takes a whole week of time, please do it. Because learning code is not about writing code, it is about to solve the problems and I want you to learn this art.
Sir.
In continuation of my earlier question.
in order to fetch GST amount in our customised Invoice
I have added a part to menu as under
[Part:MyGSTBodyPart]
Lines:MyGSTLine
Repeat:MyGSTLine:LedgerEntries
Vertical: No
[Lines:MyGSTLine]
Lines:MyCGSTLine,MySGSTLine,MyGSTLine
[Lines:MyGSTLine]
Fields:IESlNo,IESSName
Right Fields:IEQtty,IERatte,IEDisscount,IEEAmount
Local:field:IEslNo:Set as:””
Local:Field:IESSName:Set as:”CGST”
Local:Field:IEQtty:Set as:””
Local:Field:IERatte:Set as:””
Local: Field:IEDisscount:Set as:””
Local:Field:IEEAmount:Set as:$Amount
[Lines:MyGSTLine]
Fields:IESlNo,IESSName
Right Fields:IEQtty,IERatte,IEDisscount,IEEAmount
Local:field:IEslNo:Set as:””
Local:Field:IESSName:Set as:”IGST”
Local:Field:IEQtty:Set as:””
Local:Field:IERatte:Set as:””
Local:Field:IEDisscount:Set as:””
Local:Field:IEEAmount:Set as:$Amount
The Output file is attached in drop box.
Iam able to fetch value, but some error in Repeat.
Pl check
Can you give me the exact file name for your GST details so that I can fix it.
I think it is related to Ledger entry that is an easy fix. I was misunderstood it with the GST Analysis part which is a different thing.
I tried to look your both the file customised invoice and the copy file but didn’t find any reference to the gst.
So, put those things in your dropbox and give me the exact file name.
Remember I get only 5 minutes to test it. So when there are complete details available, it is easy for me to help in a better way.
All comments are subject to moderation to avoid any spamming or hacking issues and to secure the users data.
They will be appear online once they are being approved by me. Its takes time to approve the same.
Giridharan Varadharajan
somehow Iam able to fetch GST tax details through repeat of ledger Lines over ledger entries.
I have Border alignment Problem.
Total amount fetching problem.
I have shifted the Title line to Top part.
in the Body part two sub parts one for Inventory and another for Ledger entries
In total Column it is fetching only base value and not including taxes.
Because I used the same field in both places for proper alignment.
I have shared the revised output and text Files .
Please verify and correct me
Hello Sir I am Unable to fetch Date and Voucher Item
[#Form: Sales Color]
;; Background : Yellow
Delete: Print : Printed Invoice
Add: Print : InvPrint1
[Report: InvPrint1]
Form: InvPrint1
[Form: InvPrint1]
Part:InvPrint1,CmpStatDetPart1,Itempart1
[Part: InvPrint1]
Line: InvPrint1,CmpAdd1
Border: Thin Bottom
[Line: InvPrint1]
Field: Name Field
Local: Field: Name Field: Set as: @@CmpMailName;;: Company: ##SVCurrentCompany
Local: Field: Name Field: Align:Center
Local: Field: Name Field: Style: Large Bold
Local: Field: Name Field: Full Width: Yes
Height: 2
Indent: 25
[Line: CmpAdd1]
Field: Name Field
Local: Field: Name Field: Set as: @@CmpAddress
Local: Field: Name Field: Align: Center
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style: Large Bold
[Part: CmpStatDetPart1]
Parts: CmpLeft,CmpMiddle
Right Part: CmpRightPart
;;Common Border:Yes ;; for perfect alignment
Border: Thin Box
Height:7
[Part: CmpLeft]
Line: MyLine1
Border: Thin Right
Common Border: Yes
[line: Myline1]
Field: Name Field
Local: Field: Name Field: Set as: “Left”
Local: Field: Name Field: Style: Arial
[Part: CmpMiddle]
Line: MidLine1
Border: Thin Right
Common Border: Yes
[Line: MidLine1]
Field: Name Field
Local: Field: Name Field: Set as: “Middle”
Local: Field: Name Field: Style: Arial
[Part: CmpRightPart]
Line: Invno,InvDate
Border:Thin Right
Common Border: Yes
[Line: Invno]
Field: Name Field,Invno
Local: Field: Name Field: Set as: “INVOICE No.”
Local: Field: Name Field: Style: Arial
[Field: Invno]
Use: Number Field
Set as:$VoucherNumber
[Line: InvDate]
Field: Name Field,Dtfld1
Local: Field: Name Field: Set as: “Date:”
Local: Field: Name Field: Style: Arial
[Field: Dtfld1]
Use: Date Field
Set as:$Date
[Part:Itempart1]
Line: InvCol1,InvDetails1
Repeat :InvDetails1 :Inventory Entries
[Line:InvCol1]
Use: InvDetails1
Local: Field:Default:Type:String
Local: Field:InvItem:Info:”Items”
Local: Field:InvItem:Border: Thin Left
Local: Field:InvItem:Space Right:30
Local: Field:InvItem:Border: Thin Right
Local: Field:InvQty1:Info:”QTY”
Local: Field:InvQty1:Border: Thin Right
Local: Field:InvRate1:Info:”Rate”
Local: Field:InvRate1:Border: Thin Right
Local: Field:Amnt:Info:”Amount”
Local: Field:Amnt:Border: Thin Right
Local:Field:Default:Align:Center
Delete:Repeat
Border: Thin Box
Space Top:.10
Space Bottom:.10
[Line:InvDetails1]
Field: InvItem,InvQty1
Right Field: InvRate1,Amnt
[Field:InvItem]
Use: Name Field
Set as: $StockItemName
[Field:InvQty1]
Use: Qty Primary Field
Set as: $BilledQty
[Field:InvRate1]
Use: Number Field
Set as: $Rate
[Field:Amnt]
Use: Amount Field
Set as: $Amount
Hello Ankit,
There are mistakes in your code and it doesn’t match with the course chapter.
Please compare every line of your code with the course chapter. You are skipping something and I want you to find out yourself what you are skipping.
Even if it takes a whole week of time, please do it. Because learning code is not about writing code, it is about to solve the problems and I want you to learn this art.
Sir.
In continuation of my earlier question.
in order to fetch GST amount in our customised Invoice
I have added a part to menu as under
[Part:MyGSTBodyPart]
Lines:MyGSTLine
Repeat:MyGSTLine:LedgerEntries
Vertical: No
[Lines:MyGSTLine]
Lines:MyCGSTLine,MySGSTLine,MyGSTLine
[Lines:MyGSTLine]
Fields:IESlNo,IESSName
Right Fields:IEQtty,IERatte,IEDisscount,IEEAmount
Local:field:IEslNo:Set as:””
Local:Field:IESSName:Set as:”CGST”
Local:Field:IEQtty:Set as:””
Local:Field:IERatte:Set as:””
Local: Field:IEDisscount:Set as:””
Local:Field:IEEAmount:Set as:$Amount
[Lines:MyGSTLine]
Fields:IESlNo,IESSName
Right Fields:IEQtty,IERatte,IEDisscount,IEEAmount
Local:field:IEslNo:Set as:””
Local:Field:IESSName:Set as:”SGST”
Local:Field:IEQtty:Set as:””
Local:Field:IERatte:Set as:””
Local:Field:IEDisscount:Set as:””
Local:Field:IEEAmount:Set as:$Amount
[Lines:MyGSTLine]
Fields:IESlNo,IESSName
Right Fields:IEQtty,IERatte,IEDisscount,IEEAmount
Local:field:IEslNo:Set as:””
Local:Field:IESSName:Set as:”IGST”
Local:Field:IEQtty:Set as:””
Local:Field:IERatte:Set as:””
Local:Field:IEDisscount:Set as:””
Local:Field:IEEAmount:Set as:$Amount
The Output file is attached in drop box.
Iam able to fetch value, but some error in Repeat.
Pl check
GST part is a complex Part. It will be covered in the Modules later.
Hello Giridharan,
Can you give me the exact file name for your GST details so that I can fix it.
I think it is related to Ledger entry that is an easy fix. I was misunderstood it with the GST Analysis part which is a different thing.
I tried to look your both the file customised invoice and the copy file but didn’t find any reference to the gst.
So, put those things in your dropbox and give me the exact file name.
Remember I get only 5 minutes to test it. So when there are complete details available, it is easy for me to help in a better way.
Giridharan Varadharajan
Why my Comments uploaded are not finding here
All comments are subject to moderation to avoid any spamming or hacking issues and to secure the users data.
They will be appear online once they are being approved by me. Its takes time to approve the same.
Giridharan Varadharajan
somehow Iam able to fetch GST tax details through repeat of ledger Lines over ledger entries.
I have Border alignment Problem.
Total amount fetching problem.
I have shifted the Title line to Top part.
in the Body part two sub parts one for Inventory and another for Ledger entries
In total Column it is fetching only base value and not including taxes.
Because I used the same field in both places for proper alignment.
I have shared the revised output and text Files .
Please verify and correct me
File name please. It will help me to offer any help quickly.
sir please can you tell me how to print same invoice two times ( left and Right)in single page.