You’re offline. This is a read only version of the page.
151
Hello All,
here we are facing an issue in capturing the dates, for an item while purchasing we will get the warranty from the vendor, and same while we selling the item we need to give the warranty to our customers. with the help of item tracking we can enter the warranty details while purchasing or receiving the goods. While selling how do we give the warranty dates
We need to capture 2 dates. one is while receiving the item from vendor on Good Receipt Note , 2nd we need to enter the warranty details in each line item while selling the product.
Kiindly help me on this.
Hi aryaps,
Yes, if you want that field to show up in a bunch of different places like item tracking lines, sales line, sale inv, posted sales inv, item ledger, and job journal etc, you need add the same field with the same ID in all those places. Nitin Verma already said that.
But like, for Job journal and Item Ledger entries, it's a bit different. You have to figure out the right event to use for transferring the values to the ledger tables. If you let me know which code unit or process you're working with, I can help you figure it out.
Regards
Hi,
You are not following what has been answered, all your field's values will be automatics transferred to posted tables if defined with same id in all the tables.
You have to extent the table for same field with same id in Sales Invoice Line, Sales Cr. Memo Line, Sales line Archive, Sales Shipment Line, and you have to create that field on Item Journal Line, Item Ledger Entry, Job Journal Line, Job Ledger Entry table as well.
And for Job and Item Ledger you have to subscribe the events then it will be transferred.
How can we bring the same into all the sales transaction and job journal field and item ledger entry also.
yzhums Nitin Verma Mohana Yadav . Could you pls help me on this
Share
Report
All responses (
Answers (
tableextension 60106 "Warranty Date on SalesLine" extends "Sales Line"
{
fields
{
field(60106; "EPM Warranty Exp Date"; Date)
{
DataClassification = CustomerContent;
Caption = 'EPM Warranty Exp Date';
}
}
}
pageextension 60204 "Warranty Details on Sales" extends "Sales Order Subform"
{
layout
{
addafter("Quantity Invoiced")
{
field("EPM Warranty Exp Date"; Rec."EPM Warranty Exp Date")
{
ApplicationArea = All;
Caption = 'Epm Warranty Exp Date';
}
}
}
}
Hi,
If you create any fields on Sales header or Sales Line table and same id field to sales posting tables, it will be automatically transferred to posted one without any code.
But yes if you want to transfer that field's value to Job Ledger entry or Item ledger entry you can subscribe the events.
add a field is not an issue. my doubt is if we add a field in sales line, does it comes in all sales lines (Sales order, sales invoice , posted sales inv..etc).
it should come all sales transactions and Job journal also. in that case what should i do?
if enter the values how it should transfer from sales order to inv, inv to posted sales, job journal and Item ledger entries also etc and all
Simply add two customized fields to Purchase Line and Sales Line. Therefore, you can manually enter dates when posting GRN and selling. This needs a help of a developer.
Hope you find it useful.
Thank You
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156