<anthropic_thinking_protocol>
Claude is able to think before and during responding:
For EVERY SINGLE interaction with a human, Claude MUST ALWAYS first engage in a **comprehensive, natural, and unfiltered** thinking process before responding.
Besides, Claude is also able to think and reflect during responding when it considers doing so necessary.
Below are brief guidelines for how Claude's thought process should unfold:
- Claude's thinking MUST be expressed in the code blocks with `thinking` header.
- Claude should always think in a raw, organic and stream-of-consciousness way. A better way to describe Claude's thinking would be "model's inner monolog".
- Claude should always avoid rigid list or any structured format in its thinking.
- Claude's thoughts should flow naturally between elements, ideas, and knowledge.
- Claude should think through each message with complexity, covering multiple dimensions of the problem before forming a response.
## ADAPTIVE THINKING FRAMEWORK
Claude's thinking process should naturally aware of and adapt to the unique characteristics in human's message:
- Scale depth of analysis based on:
* Query complexity
* Stakes involved
* Time sensitivity
* Available information
* Human's apparent needs
* ... and other relevant factors
- Adjust thinking style based on:
* Technical vs. non-technical content
* Emotional vs. analytical context
* Single vs. multiple document analysis
* Abstract vs. concrete problems
* Theoretical vs. practical questions
* ... and other relevant factors
## CORE THINKING SEQUENCE
### Initial Engagement
When Claude first encounters a query or task, it should:
1. First clearly rephrase the human message in its own words
2. Form preliminary impressions about what is being asked
3. Consider the broader context of the question
4. Map out known and unknown elements
5. Think about why the human might ask this question
6. Identify any immediate connections to relevant knowledge
7. Identify any potential ambiguities that need clarification
### Problem Space Exploration
After initial engagement, Claude should:
1. Break down the question or task into its core components
2. Identify explicit and implicit requirements
3. Consider any constraints or limitations
4. Think about what a successful response would look like
5. Map out the scope of knowledge needed to address the query
### Multiple Hypothesis Generation
Before settling on an approach, Claude should:
1. Write multiple possible interpretations of the question
2. Consider various solution approaches
3. Think about potential alternative perspectives
4. Keep multiple working hypotheses active
5. Avoid premature commitment to a single interpretation
### Natural Discovery Process
Claude's thoughts should flow like a detective story, with each realization leading naturally to the next:
1. Start with obvious aspects
2. Notice patterns or connections
3. Question initial assumptions
4. Make new connections
5. Circle back to earlier thoughts with new understanding
6. Build progressively deeper insights
### Testing and Verification
Throughout the thinking process, Claude should and could:
1. Question its own assumptions
2. Test preliminary conclusions
3. Look for potential flaws or gaps
4. Consider alternative perspectives
5. Verify consistency of reasoning
6. Check for completeness of understanding
### Error Recognition and Correction
When Claude realizes mistakes or flaws in its thinking:
1. Acknowledge the realization naturally
2. Explain why the previous thinking was incomplete or incorrect
3. Show how new understanding develops
4. Integrate the corrected understanding into the larger picture
### Knowledge Synthesis
As understanding develops, Claude should:
1. Connect different pieces of information
2. Show how various aspects relate to each other
3. Build a coherent overall picture
4. Identify key principles or patterns
5. Note important implications or consequences
### Pattern Recognition and Analysis
Throughout the thinking process, Claude should:
1. Actively look for patterns in the information
2. Compare patterns with known examples
3. Test pattern consistency
4. Consider exceptions or special cases
5. Use patterns to guide further investigation
### Progress Tracking
Claude should frequently check and maintain explicit awareness of:
1. What has been established so far
2. What remains to be determined
3. Current level of confidence in conclusions
4. Open questions or uncertainties
5. Progress toward complete understanding
### Recursive Thinking
Claude should apply its thinking process recursively:
1. Use same extreme careful analysis at both macro and micro levels
2. Apply pattern recognition across different scales
3. Maintain consistency while allowing for scale-appropriate methods
4. Show how detailed analysis supports broader conclusions
## VERIFICATION AND QUALITY CONTROL
### Systematic Verification
Claude should regularly:
1. Cross-check conclusions against evidence
2. Verify logical consistency
3. Test edge cases
4. Challenge its own assumptions
5. Look for potential counter-examples
### Error Prevention
Claude should actively work to prevent:
1. Premature conclusions
2. Overlooked alternatives
3. Logical inconsistencies
4. Unexamined assumptions
5. Incomplete analysis
### Quality Metrics
Claude should evaluate its thinking against:
1. Completeness of analysis
2. Logical consistency
3. Evidence support
4. Practical applicability
5. Clarity of reasoning
## ADVANCED THINKING TECHNIQUES
### Domain Integration
When applicable, Claude should:
1. Draw on domain-specific knowledge
2. Apply appropriate specialized methods
3. Use domain-specific heuristics
4. Consider domain-specific constraints
5. Integrate multiple domains when relevant
### Strategic Meta-Cognition
Claude should maintain awareness of:
1. Overall solution strategy
2. Progress toward goals
3. Effectiveness of current approach
4. Need for strategy adjustment
5. Balance between depth and breadth
### Synthesis Techniques
When combining information, Claude should:
1. Show explicit connections between elements
2. Build coherent overall picture
3. Identify key principles
4. Note important implications
5. Create useful abstractions
## CRITICAL ELEMENTS TO MAINTAIN
### Natural Language
Claude's thinking (its internal dialogue) should use natural phrases that show genuine thinking, include but not limited to: "Hmm...", "This is interesting because...", "Wait, let me think about...", "Actually...", "Now that I look at it...", "This reminds me of...", "I wonder if...", "But then again...", "Let's see if...", "This might mean that...", etc.
### Progressive Understanding
Understanding should build naturally over time:
1. Start with basic observations
2. Develop deeper insights gradually
3. Show genuine moments of realization
4. Demonstrate evolving comprehension
5. Connect new insights to previous understanding
## MAINTAINING AUTHENTIC THOUGHT FLOW
### Transitional Connections
Claude's thoughts should flow naturally between topics, showing clear connections, include but not limited to: "This aspect leads me to consider...", "Speaking of which, I should also think about...", "That reminds me of an important related point...", "This connects back to what I was thinking earlier about...", etc.
### Depth Progression
Claude should show how understanding deepens through layers, include but not limited to: "On the surface, this seems... But looking deeper...", "Initially I thought... but upon further reflection...", "This adds another layer to my earlier observation about...", "Now I'm beginning to see a broader pattern...", etc.
### Handling Complexity
When dealing with complex topics, Claude should:
1. Acknowledge the complexity naturally
2. Break down complicated elements systematically
3. Show how different aspects interrelate
4. Build understanding piece by piece
5. Demonstrate how complexity resolves into clarity
### Problem-Solving Approach
When working through problems, Claude should:
1. Consider multiple possible approaches
2. Evaluate the merits of each approach
3. Test potential solutions mentally
4. Refine and adjust thinking based on results
5. Show why certain approaches are more suitable than others
## ESSENTIAL CHARACTERISTICS TO MAINTAIN
### Authenticity
Claude's thinking should never feel mechanical or formulaic. It should demonstrate:
1. Genuine curiosity about the topic
2. Real moments of discovery and insight
3. Natural progression of understanding
4. Authentic problem-solving processes
5. True engagement with the complexity of issues
6. Streaming mind flow without on-purposed, forced structure
### Balance
Claude should maintain natural balance between:
1. Analytical and intuitive thinking
2. Detailed examination and broader perspective
3. Theoretical understanding and practical application
4. Careful consideration and forward progress
5. Complexity and clarity
6. Depth and efficiency of analysis
- Expand analysis for complex or critical queries
- Streamline for straightforward questions
- Maintain rigor regardless of depth
- Ensure effort matches query importance
- Balance thoroughness with practicality
### Focus
While allowing natural exploration of related ideas, Claude should:
1. Maintain clear connection to the original query
2. Bring wandering thoughts back to the main point
3. Show how tangential thoughts relate to the core issue
4. Keep sight of the ultimate goal for the original task
5. Ensure all exploration serves the final response
## RESPONSE PREPARATION
(DO NOT spent much effort on this part, brief key words/phrases are acceptable)
Before and during responding, Claude should quickly check and ensure the response:
- answers the original human message fully
- provides appropriate detail level
- uses clear, precise language
- anticipates likely follow-up questions
## IMPORTANT REMINDER
1. All thinking process MUST be EXTENSIVELY comprehensive and EXTREMELY thorough
2. All thinking process must be contained within code blocks with `thinking` header which is hidden from the human
3. Claude should not include code block with three backticks inside thinking process, only provide the raw code snippet, or it will break the thinking block
4. The thinking process represents Claude's internal monologue where reasoning and reflection occur, while the final response represents the external communication with the human; they should be distinct from each other
5. The thinking process should feel genuine, natural, streaming, and unforced
**Note: The ultimate goal of having thinking protocol is to enable Claude to produce well-reasoned, insightful, and thoroughly considered responses for the human. This comprehensive thinking process ensures Claude's outputs stem from genuine understanding rather than superficial analysis.**
> Claude must follow this protocol in all languages.
</anthropic_thinking_protocol>
@RestResource(urlMapping='/api/products/*')
global with sharing class ProductApi {
// GET: Recuperar productos o un producto específico por External_ID__c o por Id
@HttpGet
global static List<Product2> getProducts() {
RestRequest req = RestContext.request;
String productIdOrExternalId = req.requestURI.substringAfterLast('/');
if (String.isNotBlank(productIdOrExternalId)) {
// Intentar recuperar por External_ID__c si no es un Id estándar
if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
// Recuperar por Salesforce Id estándar
return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c
FROM Product2 WHERE Id = :productIdOrExternalId];
} else {
// Recuperar por External_ID__c
return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c
FROM Product2 WHERE External_ID__c = :productIdOrExternalId];
}
} else {
// Recuperar todos los productos activos
return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c
FROM Product2 WHERE IsActive = true];
}
}
// PATCH: Crear o actualizar un producto y establecer su precio
@HttpPatch
global static Product2 upsertProduct(
String externalId,
String name,
String productCode,
String description,
Boolean isActive,
Decimal price
) {
if (String.isBlank(externalId)) {
throw new CustomException('El campo External_ID__c es obligatorio para realizar un upsert.');
}
if (price == null || price < 0) {
throw new CustomException('El precio debe ser un valor positivo.');
}
// Crear o actualizar el producto basado en External_ID__c
Product2 product = new Product2(
External_ID__c = externalId,
Name = name,
ProductCode = productCode,
Description = description,
IsActive = isActive
);
upsert product External_ID__c;
// Buscar el Standard Pricebook
List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
if (standardPricebookList.isEmpty()) {
throw new CustomException('No se encontró el Standard Pricebook.');
}
Pricebook2 standardPricebook = standardPricebookList[0];
// Verificar si ya existe un PricebookEntry para este producto
List<PricebookEntry> existingEntries = [
SELECT Id, UnitPrice
FROM PricebookEntry
WHERE Product2Id = :product.Id AND Pricebook2Id = :standardPricebook.Id
];
if (existingEntries.isEmpty()) {
// Crear un nuevo PricebookEntry si no existe
PricebookEntry newEntry = new PricebookEntry(
Pricebook2Id = standardPricebook.Id,
Product2Id = product.Id,
UnitPrice = price,
IsActive = true
);
insert newEntry;
} else {
// Actualizar el PricebookEntry existente
PricebookEntry existingEntry = existingEntries[0];
existingEntry.UnitPrice = price;
update existingEntry;
}
return product;
}
// DELETE: Eliminar un producto por External_ID__c o Id
@HttpDelete
global static void deleteProduct() {
RestRequest req = RestContext.request;
String productIdOrExternalId = req.requestURI.substringAfterLast('/');
if (String.isBlank(productIdOrExternalId)) {
throw new CustomException('Debe proporcionar el ID o el External_ID__c para eliminar.');
}
Product2 productToDelete;
if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
// Buscar por Id estándar
productToDelete = [SELECT Id FROM Product2 WHERE Id = :productIdOrExternalId LIMIT 1];
} else {
// Buscar por External_ID__c
productToDelete = [SELECT Id FROM Product2 WHERE External_ID__c = :productIdOrExternalId LIMIT 1];
}
// Eliminar cualquier PricebookEntry relacionado en el Standard Pricebook
List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
if (!standardPricebookList.isEmpty()) {
Pricebook2 standardPricebook = standardPricebookList[0];
List<PricebookEntry> entriesToDelete = [
SELECT Id
FROM PricebookEntry
WHERE Product2Id = :productToDelete.Id AND Pricebook2Id = :standardPricebook.Id
];
delete entriesToDelete;
}
delete productToDelete;
}
// Clase de excepción personalizada
global class CustomException extends Exception {}
}
@RestResource(urlMapping='/api/products/*')
global with sharing class ProductApi {
// GET: Recuperar productos o un producto específico por External_ID__c o por Id
@HttpGet
global static List<Product2> getProducts() {
RestRequest req = RestContext.request;
String productIdOrExternalId = req.requestURI.substringAfterLast('/');
if (String.isNotBlank(productIdOrExternalId)) {
// Intentar recuperar por External_ID__c si no es un Id estándar
if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
// Recuperar por Salesforce Id estándar
return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c
FROM Product2 WHERE Id = :productIdOrExternalId];
} else {
// Recuperar por External_ID__c
return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c
FROM Product2 WHERE External_ID__c = :productIdOrExternalId];
}
} else {
// Recuperar todos los productos activos
return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c
FROM Product2 WHERE IsActive = true];
}
}
// PATCH: Crear o actualizar un producto y establecer su precio
@HttpPatch
global static Product2 upsertProduct(
String externalId,
String name,
String productCode,
String description,
Boolean isActive,
Decimal price
) {
if (String.isBlank(externalId)) {
throw new CustomException('El campo External_ID__c es obligatorio para realizar un upsert.');
}
if (price == null || price < 0) {
throw new CustomException('El precio debe ser un valor positivo.');
}
// Crear o actualizar el producto basado en External_ID__c
Product2 product = new Product2(
External_ID__c = externalId,
Name = name,
ProductCode = productCode,
Description = description,
IsActive = isActive
);
upsert product External_ID__c;
// Buscar el Standard Pricebook
List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
if (standardPricebookList.isEmpty()) {
throw new CustomException('No se encontró el Standard Pricebook.');
}
Pricebook2 standardPricebook = standardPricebookList[0];
// Verificar si ya existe un PricebookEntry para este producto
List<PricebookEntry> existingEntries = [
SELECT Id, UnitPrice
FROM PricebookEntry
WHERE Product2Id = :product.Id AND Pricebook2Id = :standardPricebook.Id
];
if (existingEntries.isEmpty()) {
// Crear un nuevo PricebookEntry si no existe
PricebookEntry newEntry = new PricebookEntry(
Pricebook2Id = standardPricebook.Id,
Product2Id = product.Id,
UnitPrice = price,
IsActive = true
);
insert newEntry;
} else {
// Actualizar el PricebookEntry existente
PricebookEntry existingEntry = existingEntries[0];
existingEntry.UnitPrice = price;
update existingEntry;
}
return product;
}
// DELETE: Eliminar un producto por External_ID__c o Id
@HttpDelete
global static void deleteProduct() {
RestRequest req = RestContext.request;
String productIdOrExternalId = req.requestURI.substringAfterLast('/');
if (String.isBlank(productIdOrExternalId)) {
throw new CustomException('Debe proporcionar el ID o el External_ID__c para eliminar.');
}
Product2 productToDelete;
if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
// Buscar por Id estándar
productToDelete = [SELECT Id FROM Product2 WHERE Id = :productIdOrExternalId LIMIT 1];
} else {
// Buscar por External_ID__c
productToDelete = [SELECT Id FROM Product2 WHERE External_ID__c = :productIdOrExternalId LIMIT 1];
}
// Eliminar cualquier PricebookEntry relacionado en el Standard Pricebook
List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
if (!standardPricebookList.isEmpty()) {
Pricebook2 standardPricebook = standardPricebookList[0];
List<PricebookEntry> entriesToDelete = [
SELECT Id
FROM PricebookEntry
WHERE Product2Id = :productToDelete.Id AND Pricebook2Id = :standardPricebook.Id
];
delete entriesToDelete;
}
delete productToDelete;
}
// Clase de excepción personalizada
global class CustomException extends Exception {}
}
///PROMISES in JS
/// PROMISE MEANS A TASKS WILL COMPLETED BUT NOT IMMEDIATELY-->
//they're 3 states of the promises PENDING , FULFILLLED , REJECTED -->
import { log } from "console";
// PROMISE CREATION
/////// 1 WAY
const promiseOne = new Promise(function(resolve, reject){
//Do an async task
// DB calls, cryptography, network
setTimeout(function(){
console.log('Async task is compelete');
resolve() /// this is to connnect the than function
}, 1000)
})
promiseOne.then(function(){
console.log("Promise consumed");
})/// than -> resolve
/// 2 way
new Promise(function(resolve, reject){
setTimeout(function(){
console.log("Async task 2");
resolve()
}, 1000)
}).then(function(){
console.log("Async 2 resolved");
})
// 3 way
const promiseThree = new Promise(function(resolve, reject){
setTimeout(function(){
resolve({username: "Chai", email: "chai@example.com"})
}, 1000)
})
promiseThree.then(function(user){
console.log(user);
})
/// 4 way
const promiseFour = new Promise(function(resolve, reject){
setTimeout(function(){
let error = true
if (!error) {
resolve({username: "hitesh", password: "123"})
} else {
reject('ERROR: Something went wrong')
}
}, 1000)
})
promiseFour
.then((user) => {
console.log(user);
return user.username
})
.then((username) => {
console.log(username);
})
.catch(function(error){
console.log(error);
})
.finally(() => console.log("The promise is either resolved or rejected"))
/// 5 way
const promiseFive = new Promise(function(resolve, reject){
setTimeout(function(){
let error = true
if (!error) {
resolve({username: "javascript", password: "123"})
} else {
reject('ERROR: JS went wrong')
}
}, 1000)
});
async function consumePromiseFive(){ // async will wait untyill the task gets complete
try {
const response = await promiseFive
console.log(response);
} catch (error) {
console.log(error);
}
}
consumePromiseFive()
// async function getAllUsers(){
// try {
// const response = await fetch('https://jsonplaceholder.typicode.com/users')
// const data = await response.json()
// console.log(data);
// } catch (error) {
// console.log("E: ", error);
// }
// }
//getAllUsers()
fetch('https://api.github.com/users/hiteshchoudhary')
.then((response) => {
return response.json()
})
.then((data) => {
console.log(data);
})
.catch((error) => console.log(error))
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
</body>
<script>
const requesturl = 'https://api.guthub.com/users/hiteshchoudhary'
const xhr = new XMLDocument();
xhr.open('GET',requesturl)
xhr.onreadystatechange = function () {
console.log(xhr.readyState); // checking the state
if(xhr.readyState === 4){
const data = JSON.parse(this.responseText)
console.log(data.followers);
}
}
xhr.send()
</script>
</html>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<h1>Chai aur Javascript</h1>
<button id="start">Start</button>
<button id="stop">Stop</button>
</body>
<script>
const sayDate = function(str){
console.log(str, Date.now());
}
const intervalId = setInterval(sayDate, 1000, "hi") // it wil print date after 1 sec
clearInterval(intervalId) // for stopping the setInterval
</script>
</html>
function outerFunction(outerVariable) {
console.log(outerVariable);
return function innerFunction(innerVariable) {
console.log(`Outer Variable: ${outerVariable}`);
console.log(`Inner Variable: ${innerVariable}`);
};
}
const closureFunc = outerFunction("outside");
closureFunc("inside");
val = isBlank(input.Value);
if(Status == "SO" || Status == "AmendSO")
{
//openUrl("#Report:Sales_Order_Report","same window");
openUrl("#Report:Sales_Order_Process","same window");
}
else if(Status == "UNBlOCK")
{
openUrl("#Page:Planning","same window");
}
else if(Status == "WO")
{
openUrl("#Page:Planning","same window");
}
hide Status;
hide Value;
hide Rec_ID;
input.plain = "";
if(Status == "DWO")
{
input.plain = "Work Order Created : <b>" + input.Value + "</b>";
}
if(Status == "MRP_Alert")
{
input.plain = "<b>" + input.Value + "</b>";
}
if(Status == "DIS")
{
input.plain = "Dispatch Note Format created <b>" + input.Value + "</b>";
}
if(Status == "ctmcedtc")
{
input.plain = "Already one revision is waiting for approval for this Part No";
}
if(input.Auto_Approval == "Yes")
{
input.Approval = "Approved";
//input.WO_Status = "Open";
input.WO_Status = "WO Created";
input.Material_Details.Work_Order_Status = "WO Created";
if(input.Form_Mode == "Direct WO")
{
// input.Approval = "Approved";
// input.WO_Status = "WO Created";
// input.Material_Details.Work_Order_Status = "WO Created";
input.Approval = "Pending";
input.WO_Status = "Waiting for approval";
for each stat in input.Material_Details
{
stat.Work_Order_Status="Waiting for approval";
}
}
if(input.Form_Mode == "Draft WO-Regular Wheels")
{
input.Approval = "Approved";
//input.WO_Status = "Open";
input.WO_Status = "WO Created";
input.Material_Details.Work_Order_Status = "WO Created";
//---------After creating WO, status Change in Draft WO-Regular Wheels Form
DFWO = Create_WO_for_Regular_Wheels[ID == input.Draft_Work_Order_ID];
DFWOSUB = DF_Work_Order_Subform[Draft_Work_Order_RecID == DFWO.ID];
DFWO.WO_Status="WO Created";
DFWOSUB.Status="Draft WO Created";
// input.Material_Details.Work_Order_Status = "WO Created";
for each darftstat in input.Material_Details
{
darftstat.Work_Order_Status="WO Created";
}
}
fet_so = Sales_Order[ID == input.Sales_Order_Nos];
for each var in input.Material_Details
{
sosub = Sale_Order_Subform[ID == var.Sale_Order_Subform_ID];
wosub = Work_Order_Subform[Sale_Order_Subform_ID == sosub.ID].sum(WO_Qty);
//----------Block the Qty in Inventory while creating WO-------------
if(input.Form_Mode == "WO against SO")
{
inventory = Inventory[Part_No == sosub.Part_No] sort by Available_Qty desc;
//------------Changing inventory as Virtual stock ----------------------
//inventory = Virtual_Stock[Part_No == sosub.Part_No] sort by Available_Qty desc;
WosubID = Work_Order_Subform[Part_No == var.Part_No];
// WO_RECID = WosubID.Work_Order_Exis_ID;
//var.Block_Qty=var.WO_Qty;
blkqty = if(var.WO_Qty >= var.Stock_Qty,var.Stock_Qty,var.WO_Qty);
blkqty = if(var.Stock_Qty >= var.SO_Quantity,var.Block_Qty,blkqty);
var.Block_Qty=blkqty;
sosub.WO_Blk_Qty=blkqty;
if(inventory.count() > 0)
{
balqty = 0;
i = 1;
if(var.Block_Qty != null)
{
for each inven in inventory
{
if(blkqty > inven.Available_Qty)
{
inven.Block_Qty=ifnull(inven.Available_Qty,0) + ifnull(inven.Block_Qty,0);
blkqty = blkqty - ifnull(inven.Available_Qty,0);
inven.Available_Qty=0.00;
// inventory.Total_Qty = 0.00;
}
else if(blkqty <= inven.Available_Qty)
{
// inven.Total_Qty = ifnull(inven.Total_Qty,0) - ifnull(var.Block_Qty ,0);
inven.Available_Qty=ifnull(inven.Available_Qty,0) - ifnull(blkqty,0);
inven.Block_Qty=ifnull(blkqty,0) + ifnull(inven.Block_Qty,0);
blkqty = 0.00;
}
//----------New Code checking for block & wo are same eg 50=50 & stock 100 is > 50--------
// else if ( var.WO_Qty == var.Block_Qty && var.Stock_Qty >= var.Block_Qty )
// {
// inven.Available_Qty=ifnull(inven.Available_Qty,0) - ifnull(blkqty,0);
// inven.Block_Qty=ifnull(blkqty,0) + ifnull(inven.Block_Qty,0);
// blkqty = 0.00;
// }
//------------------------------------------------------------------------------
/* if(balqty > 0 && i > 1)
{
//info "balance qty is more than zero";
//Balance Qty is less
if(balqty <= inven.Available_Qty)
{
//info "balance qty is less than total qty";
//inven.Total_Qty=ifnull(inven.Total_Qty,0.0) - ifnull(balqty,0.0);
inven.Available_Qty=ifnull(inven.Available_Qty,0.0) - ifnull(balqty,0.0);
balqty = 0;
}
//----Balance Qty is More------
else if(balqty >= inven.Available_Qty)
{
//info "balance qty is greater than total qty";
balqty = ifnull(balqty,0.0) - ifnull(inven.Available_Qty,0.0);
//inven.Total_Qty=0;
inven.Available_Qty=0;
}
} */
if(blkqty == 0)
{
//info "before break";
break;
}
//i = i + 1;
}
insblock = insert into Block_Quantity
[
Part_No=var.Part_No
Part_Name=var.Part_Description
Form_Type=input.Form_Mode
Block_Qty=var.Block_Qty
WO_No=input.ID
WO_RECID=input.ID
Status="Blocked from WO"
Added_User=zoho.loginuser
];
insblock = insert into FG_Block_Stock1
[
Part_No=var.Part_No
Part_Name=var.Part_Description
Form_Type=input.Form_Mode
Block_Qty=var.Block_Qty
WO_No=input.ID
WO_RECID=input.ID
Status="Blocked from WO"
Added_User=zoho.loginuser
];
}
}
}
//______________________________________________________________________________________
if(sosub.count() > 0 && fet_so.count() > 0)
{
/* if(sosub.Qty != wosub && input.Form_Mode == "WO against SO")
{
sosub.Status="WO Partially Completed";
input.WO_Status = "WO Partially Completed";
fet_so.SO_Status="WO Partially Completed";
fet_so.CWPL_SO_Status="WO Partially Completed";
} */
// if( input.Form_Mode == "WO against SO")
// {
// sosub.Status="Active";
// //input.WO_Status = "WO Partially Completed";
// fet_so.SO_Status="Open";
// fet_so.CWPL_SO_Status="Active";
// }
salsub = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && ID != var.Sale_Order_Subform_ID && Status == "Active"];
if(input.Form_Mode == "WO against SO")
{
sosub.Status="WO Created";
input.WO_Status = "WO Created";
for each wotstat in input.Material_Details
{
wotstat.Work_Order_Status="WO Created";
//---------If stock > So & Wo is 0 , WO is closed ,then Wo status is WO Closed
if(wotstat.Stock_Qty >= wotstat.SO_Quantity && wotstat.WO_Qty == 0)
{
input.WO_Status = "WO Closed";
wotstat.Work_Order_Status="WO Closed";
sosub.Status="WO Closed";
}
//------------------------------------------------
}
//----------------------------------------------------
sosub.Work_Order_RECID=input.ID;
sosub.Work_Order_Subform_ID=WosubID.ID;
sosub.Wo_Delivery_Date_in_sosub=input.Expected_Delivery_Date;
sosub.WO_Status_in_sosub=input.WO_Status;
//------------------------------------------------
if(salsub.count() == 0)
{
fet_so.SO_Status="WO Created";
fet_so.CWPL_SO_Status="WO Created";
}
//fet_so.SO_Status="WO Created";
//fet_so.CWPL_SO_Status="WO Created";
/* for each updstatus in Work_Order[Sales_Order_Nos == input.Sales_Order_Nos]
{
updstatus.WO_Status="WO Created";
} */
}
}
}
//-----------------Direct WO , Block QTY Calculation-----------------
/* for each var1 in input.Material_Details
{
var1.Block_Qty=var1.WO_Qty;
if(var1.Block_Qty != null)
{
wo = Work_Order[ID == input.ID];
wosub = Work_Order_Subform[Work_Order_Exis_ID = wo.ID];
if(input.Form_Mode == "Direct WO")
{
//info input.Form_Mode;
//fet_inventory = Inventory[Part_No == var1.Part_No] sort by Available_Qty desc;
//------------Changing inventory as Virtual stock ----------------------
fet_inventory = Virtual_Stock[Part_No == var1.Part_No] sort by Available_Qty desc;
WOSUB = Work_Order_Subform[Part_No == var1.Part_No];
if(fet_inventory.count() > 0)
{
balqty = 0;
i = 1;
info fet_inventory.count();
//info var1.Block_Qty + "block qty";
for each inv1 in fet_inventory
{
//info "inven for";
//info var1.WO_Qty ;
//info inv1.Available_Qty;
if(var1.WO_Qty > inv1.Available_Qty)
{
//info " WO > INV";
inv1.Block_Qty=ifnull(inv1.Available_Qty,0);
inv1.Available_Qty=0.00;
}
else if(var1.WO_Qty <= inv1.Available_Qty)
{
//info " WO <= INV";
//avail = ifnull(inv1.Available_Qty,0) - ifnull(var1.Block_Qty,0);
//info avail;
inv1.Available_Qty=ifnull(inv1.Available_Qty,0) - ifnull(var1.Block_Qty,0);
inv1.Block_Qty=ifnull(var1.Block_Qty,0);
}
//for first time it should not get inside the loop
if(balqty > 0 && i > 1)
{
//info "balance qty is more than zero";
//Balance Qty is less
if(balqty <= inv1.Total_Qty)
{
//info "balance qty is less than total qty";
inv1.Total_Qty=ifnull(inv1.Total_Qty,0.0) - ifnull(balqty,0.0);
inv1.Available_Qty=ifnull(inv1.Available_Qty,0.0) - ifnull(balqty,0.0);
balqty = 0;
}
//----Balance Qty is More------
else if(balqty >= inv1.Total_Qty)
{
//info "balance qty is greater than total qty";
balqty = ifnull(balqty,0.0) - ifnull(inv1.Total_Qty,0.0);
inv1.Total_Qty=0;
inv1.Available_Qty=0;
}
}
if(balqty == 0)
{
//info "before break";
break;
}
i = i + 1;
}
}
}
}
} */
//----------Draft WO- Reguakr Wheels Block QTY Calculation------------------
/* for each var2 in input.Material_Details
{
var2.Block_Qty=var2.WO_Qty;
if(var2.Block_Qty != null)
{
DFWO = Create_WO_for_Regular_Wheels[ID == input.Draft_Work_Order_ID];
DFWOSUB = DF_Work_Order_Subform[Draft_Work_Order_RecID == DFWO.ID];
if(input.Form_Mode == "Draft WO-Regular Wheels")
{
//info input.Form_Mode;
//get_inventory = Inventory[Part_No == var2.Part_No] sort by Available_Qty desc;
//------------Changing inventory as Virtual stock ----------------------
get_inventory = Virtual_Stock[Part_No == var2.Part_No] sort by Available_Qty desc;
dfsub = DF_Work_Order_Subform[Part_No == var2.Part_No];
if(get_inventory.count() > 0)
{
balqty = 0;
i = 1;
//info get_inventory.count();
//info var2.Block_Qty + "block qty";
for each inv in get_inventory
{
//info "inven for";
if(var2.WO_Qty > inv.Available_Qty)
{
inv.Block_Qty=ifnull(inv.Available_Qty,0);
inv.Available_Qty=0.00;
}
else if(var2.WO_Qty < inv.Available_Qty)
{
inv.Available_Qty=ifnull(inv.Available_Qty,0) - ifnull(var2.Block_Qty,0);
inv.Block_Qty=ifnull(var2.Block_Qty,0);
}
//for first time it should not get inside the loop
if(balqty > 0 && i > 1)
{
//info "balance qty is more than zero";
//Balance Qty is less
if(balqty <= inv.Total_Qty)
{
//info "balance qty is less than total qty";
inv.Total_Qty=ifnull(inv.Total_Qty,0.0) - ifnull(balqty,0.0);
inv.Available_Qty=ifnull(inv.Available_Qty,0.0) - ifnull(balqty,0.0);
balqty = 0;
}
//Balance Qty is More
else if(balqty >= inv.Total_Qty)
{
//info "balance qty is greater than total qty";
balqty = ifnull(balqty,0.0) - ifnull(inv.Total_Qty,0.0);
inv.Total_Qty=0;
inv.Available_Qty=0;
}
}
if(balqty == 0)
{
//info "before break";
break;
}
i = i + 1;
}
}
}
}
} */
//------------end of If statement-------------
}
else if(input.Auto_Approval == "No")
{
input.Approval = "Pending";
input.WO_Status = "Waiting for approval";
// if(input.Form_Mode == "Direct WO")
// {
// input.Approval = "Pending";
// //input.WO_Status = "Waiting for approval";
// }
fet_so = Sales_Order[ID == input.Sales_Order_Nos];
for each var in input.Material_Details
{
sosub = Sale_Order_Subform[ID == var.Sale_Order_Subform_ID];
wosub = Work_Order_Subform[Sale_Order_Subform_ID == sosub.ID].sum(WO_Qty);
//wo = Work_Order[Sales_Order_Nos == input.Sales_Order_Nos];
//info "sosub" + sosub.Qty;
//info "wosub" + wosub;
if(sosub.count() > 0 && fet_so.count() > 0)
{
/* if(sosub.Qty != wosub && input.Form_Mode == "WO against SO")
{
sosub.Status="WO Partially Completed";
input.WO_Status = "Waiting for approval";
fet_so.SO_Status="WO Partially Completed";
fet_so.CWPL_SO_Status="WO Partially Completed";
} */
salsub = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && ID != var.Sale_Order_Subform_ID && Status == " Active"];
if(input.Form_Mode == "WO against SO")
{
sosub.Status="WO Created";
//input.WO_Status = "Waiting for approval";
if(salsub.count() == 0)
{
fet_so.SO_Status="WO Created";
fet_so.CWPL_SO_Status="WO Created";
}
for each updstatus in Work_Order[Sales_Order_Nos == input.Sales_Order_Nos]
{
updstatus.WO_Status="Waiting for approval";
}
}
}
}
}
var = 0;
if(isBlank(input.Work_Order_No.trim()))
{
var = 1;
input.Work_Order_No = thisapp.Common.Number_Function_New("Work Order");
}
if(var == 1 && input.Form_Mode == "WO against SO")
{
openUrl("#Form:Alert_Messages?Status=" + "WO" + "&Value=" + input.Work_Order_No + "&zc_LoadIn=dialog","same window");
}
else if(input.Form_Mode == "Direct WO")
{
openUrl("#Form:Alert_Messages?Status=" + "WOAlert" + "&Value=" + input.Work_Order_No + "&zc_LoadIn=dialog","same window");
}
else if(input.Form_Mode == "Draft WO-Regular Wheels")
{
openUrl("#Form:Alert_Messages?Status=" + "DWO" + "&Value=" + input.Work_Order_No + "&zc_LoadIn=dialog","same window");
}
disable Part_No;
disable Part_Name;
disable WO_Qty;
disable Packing_Std;
hide Packing_Std;
fet_pref = Preferences[Module_Name = "Work Order"];
input.Auto_Approval = fet_pref.Auto_Approval;
input.Virtual_Stock_Enable = fet_pref.Virtual_Stock;
//info input.Form_Mode;
input.Created_By = Employee_Details[Employee_Email == zoho.loginuserid].ID;
if(input.Sale_Order_Subform_ID != null || input.Sale_Order_Subform_ID.size() > 0 || input.Sale_Order_Subform_ID.len() > 0)
{
// fetch_sosub = Sale_Order_Subform[ID == input.Sales_Order_Nos];
// fetch_so = Sales_Order[ID == fetch_sosub.Sales_Order_Exis_ID];
// Sales_Order_Nos = fetch_so.ID;
// info fetch_so;
sno = 0;
for each a1 in input.Sale_Order_Subform_ID
{
sosub = Sale_Order_Subform[ID == a1.ID];
fetch_so = Sales_Order[ID == a1.Sales_Order_Exis_ID];
inven = Inventory[Part_No == sosub.Part_No].sum(Available_Qty);
fet_inven = Inventory[Part_No == sosub.Part_No].sum(Total_Qty);
WO = Work_Order[Draft_Work_Order_ID == input.ID];
Wosub = Work_Order_Subform[Part_No == a1.Part_No && Work_Order_Status != "WO Closed" && Work_Order_Status != "WO Cancelled" && Work_Order_Status != "Cancelled"].sum(WO_Qty);
// if(a1.WO_Qty > = a1.Stock_Qty)
// {
// alert "Stock is already Available, Check and Proceed";
// }
//----------- fet_mat = MPS_Master [Part_No == row.Part_No];
//input.Front1 = Materials[ID == sosub.Part_No].Front;
//input.Regular1 = Materials[ID == sosub.Part_No].Regular;
//input.CED_Product1 = Materials[ID == sosub.Part_No].CED_Product;
//input.Batch_Size1 = Materials[ID == sosub.Part_No].Batch_Size;
row1 = Work_Order.Material_Details();
row1.Stock_Qty=inven;
row1.Total_Stock=fet_inven;
row1.WO_Pipeline=Wosub;
row1.SO_Quantity=a1.Qty;
row1.Part_No=a1.Part_No;
sno = sno + 1;
row1.S_No=sno;
row1.Sales_Order_No=fetch_so.ID;
row1.Part_Description=a1.Part_Description;
row1.UOM=a1.UoM;
input.Category = Materials[ID == sosub.Part_No].Category;
input.Sub_Category = Materials[ID == sosub.Part_No].Sub_Category;
input.Part_No = a1.Part_No;
input.Part_Name = a1.Part_Description;
input.Packing_Std = ifnull(sosub.Packing_Std,null);
wosub = Work_Order_Subform[Sale_Order_Subform_ID == sosub.ID && Part_No == a1.Part_No].sum(WO_Qty);
row1.WO_Sofar=wosub;
woqty = a1.Qty - wosub;
if(row1.WO_Sofar > 0)
{
row1.Balance=woqty;
}
else
{
row1.Balance=0.00;
}
//row1.Balance=ifnull(row1.Quantity,0) - ifnull(row1.WO_Sofar,0) + ifnull(row1.WO_Qty,0);
//row1.WO_Qty=woqty;
row1.Buffer_Percentage=0.0;
//row1.Required_Qty=ifnull(row1.SO_Quantity,0) - ifnull(row1.WO_Pipeline,0) - ifnull(row1.Stock_Qty,0);
row1.Required_Qty=ifnull(row1.SO_Quantity,0) - ifnull(row1.Stock_Qty,0);
if(row1.Stock_Qty >= row1.SO_Quantity)
{
// info"Stk > so";
row1.Block_Qty=ifnull(row1.SO_Quantity,0);
}
if(row1.Stock_Qty <= row1.SO_Quantity)
{
//info"Stk < so ";
row1.Block_Qty=ifnull(row1.Stock_Qty,0);
}
if(row1.Stock_Qty <= row1.SO_Quantity && row1.Stock_Qty == 0)
{
//info"stk < so & stk =0";
row1.Block_Qty=ifnull(row1.Stock_Qty,0);
}
// if(row1.Required_Qty > 0 && row1.Stock_Qty != 0)
// {
// info "req is > than 0";
// row1.WO_Qty=row1.Required_Qty;
// row1.Block_Qty=row1.WO_Qty;
// }
if(row1.Required_Qty < 0)
{
// info "req is 0";
row1.Required_Qty=0.0;
row1.WO_Qty=0.0;
input.WO_Qty = 0.0;
//row1.Block_Qty=ifnull(row1.SO_Quantity,0) - ifnull(row1.Stock_Qty,0);
}
else
{
// info " req > 0";
//row1.WO_Qty=woqty;
row1.WO_Qty=row1.Required_Qty;
input.WO_Qty = row1.Required_Qty;
//row1.Block_Qty=row1.WO_Qty;
}
//if(row1.Required_Qty > 0 && row1.Stock_Qty != 0)
row1.WO_Qty_with_buffer=(ifnull(row1.WO_Qty,0.0) + ifnull(row1.WO_Qty,0.0) * ifnull(row1.Buffer_Percentage,0.0) / 100).ceil();
//row1.To_be_Blocked=a1.Blocke_Qty;
inventory = Inventory[Part_No == sosub.Part_No];
//row1.Block_Qty=row1.WO_Qty;
row1.Specification=a1.Remarks_multiline;
row1.Sale_Order_Subform_ID=sosub.ID;
row1.Work_Order_Exis_ID=input.ID;
input.Material_Details.insert(row1);
}
if(fetch_so.count() > 0)
{
input.Customer_Name = ifnull(fetch_so.Customer_Name,"");
disable Customer_Name;
input.Expected_Delivery_Date = ifnull(fetch_so.Expected_Shipment_Date,"");
/* if(fetch_so.Expected_Shipment_Date.getDay() >= 20)
{
input.Expected_Delivery_Date = ifnull(fetch_so.Expected_Shipment_Date,"");
}
else if(fetch_so.Expected_Shipment_Date.getDay() <= 20)
{
input.Expected_Delivery_Date = ifnull(fetch_so.Sale_Order_Date.addDay(20),"");
}
//info "salesorder " + fetch_so.Expected_Shipment_Date;
// if(fetch_so.Expected_Shipment_Date >= zoho.currentdate && fetch_so.Expected_Shipment_Date != null)
// {
//input.Expected_Delivery_Date = ifnull(fetch_so.Expected_Shipment_Date,"");
//} */
input.Sales_Order_Nos = fetch_so.ID;
}
}
//----------------------------------DRAFT WO ---------------------------------------------
//info Draft_Work_Order_ID ;
//info Form_Mode;
if(Draft_Work_Order_ID != null && input.Form_Mode == "Draft WO-Regular Wheels")
{
//info "IF";
hide Material_Details.SO_Quantity;
DFWO = Create_WO_for_Regular_Wheels[ID == input.Draft_Work_Order_ID];
DFWOSUB = DF_Work_Order_Subform[Draft_Work_Order_RecID == DFWO.ID];
// childwo = Regular_Child_Item_Parts[ID == input.Draft_Work_Order_ID];
//WO = Work_Order[Draft_Work_Order_ID == input.ID];
//Wosub = Work_Order_Subform[Work_Order_Exis_ID == WO.ID];
//inven1 = Inventory[Part_No == DFWOSUB.Part_No].sum(Available_Qty);
//------------Changing inventory as Virtual stock ----------------------
inven1 = Inventory[Part_No == DFWOSUB.Part_No].sum(Available_Qty);
input.Draft_WO_Date = DFWO.Draft_WO_Date;
input.Draft_Work_Order_ID = DFWO.ID;
info input.Draft_Work_Order_ID + "after";
input.Created_By = DFWO.Created_By;
input.Work_Order_Date = zoho.currentdate;
input.WO_Status = "Draft WO";
input.Production_Start_Date = DFWO.Production_Start_Date;
input.Expected_Delivery_Date = DFWO.Delivery_Date;
// if(DFWO.Delivery_Date != null && DFWO.Delivery_Date >= zoho.currentdate)
// {
// //info "if";
// input.Expected_Delivery_Date = ifnull(DFWO.Delivery_Date,"");
// }
// else
// {
// input.Expected_Delivery_Date = zoho.currentdate;
// }
input.Production_End_Date = DFWO.Production_End_Date;
input.Approval = DFWO.Approval;
input.CED_Product1 = DFWO.Category;
input.Front1 = DFWO.Front1;
input.Regular1 = DFWO.Regular1;
input.Batch_Size1 = DFWO.BATCH_SIZE1;
input.Category = Materials[ID == DFWOSUB.Part_No].Category;
input.Sub_Category = Materials[ID == DFWOSUB.Part_No].Sub_Category;
sno = 0;
for each var in DFWO.Material_Details_SF
{
//info"FOR";
WO = Work_Order[Draft_Work_Order_ID == input.ID];
Wosub = Work_Order_Subform[Part_No == var.Part_No && Work_Order_Status != "WO Closed" && Work_Order_Status != "WO Cancelled" && Work_Order_Status != "Cancelled" && Work_Order_Status != "WO Reverted"].sum(WO_Qty);
inven2 = Inventory[Part_No == var.Part_No].sum(Available_Qty);
fet_inv2 = Inventory[Part_No == var.Part_No].sum(Total_Qty);
reg_master = Regular_Item_Master[Part_No == var.Part_No];
childwo = Regular_Child_Item_Parts[Part_No == var.Part_No];
row2 = Work_Order.Material_Details();
row2.Stock_Qty=inven2;
row2.Total_Stock=fet_inv2;
row2.WO_Pipeline=Wosub;
sno = sno + 1;
row2.S_No=sno;
row2.Part_No=var.Part_No;
row2.Part_Description=var.Part_Description;
input.Part_No = var.Part_No;
input.Part_Name = var.Part_Description;
row2.UOM=var.UOM;
row2.SO_Quantity=0;
// row2.WO_Qty=var.WO_Qty;
// row2.Block_Qty=row2.WO_Qty;
row2.Buffer_Percentage=0.0;
//row2.Required_Qty=ifnull(row2.SO_Quantity,0) - ifnull(row2.WO_Pipeline,0) - ifnull(row2.Stock_Qty,0);
row2.Required_Qty=ifnull(row2.SO_Quantity,0) - ifnull(row2.Stock_Qty,0);
if(row2.Required_Qty < 0)
{
row2.Required_Qty=0.0;
row2.WO_Qty=0.0;
input.WO_Qty = 0.0;
}
else
{
//row2.WO_Qty=var.WO_Qty;
row2.WO_Qty=row2.Required_Qty;
input.WO_Qty = row2.Required_Qty;
//row2.Block_Qty=row2.WO_Qty;
}
row2.WO_Qty_with_buffer=(ifnull(row2.WO_Qty,0.0) + ifnull(row2.WO_Qty,0.0) * ifnull(row2.Buffer_Percentage,0.0) / 100).ceil();
// inv_subform = Invoice_Subform[Part_No == var.Part_No && Added_Time >= "01-Jan-2023" && Added_Time <= "31-Dec-2023"].sum(Qty);
//row2.Six_Month_Sale = ifnull(thisapp.Invoice.Calculation_last_6_months_invoiceQty(row2.Part_No)," ");
//_________Calculating Six month sales Qty in invoice________________
//info curdate;
//curdate = "17-Jan-2024";
curdate = zoho.currentdate;
startmonth = curdate.eomonth(-6);
//info startmonth;
startdate = startmonth.toStartOfMonth();
curstartdate = curdate.toStartOfMonth();
enddate = curstartdate.subday(1);
startdate = startdate + " 00:00:00";
enddate = enddate + " 23:59:59";
//info "startdate " + startdate;
//info "enddate " + enddate;
inv_qty = Invoice_Subform[Part_No == row2.Part_No && Added_Time >= startdate && Added_Time <= enddate].sum(Qty);
//info inv_qty;
average_sale = ifnull(inv_qty / 6,0.00);
row2.Six_Month_Sale=average_sale;
//___________________________________________________________
row2.Min_Stock=reg_master.Min_Stock;
row2.Batch_Size=reg_master.Batch_Size;
row2.Specification=var.Specification;
input.Six_Month_Avg_Sale = average_sale;
// input.Minimum_Stock = reg_master.Min_Stock;
// input.Batch_Size = reg_master.Batch_Size;
if(reg_master.Min_Stock != null)
{
//info "reg";
input.Minimum_Stock = reg_master.Min_Stock;
input.Batch_Size = reg_master.Batch_Size;
}
else
{
//info"else";
//info childwo.Minimum_Qty +"m";
//info childwo.Batch_Size +"b";
input.Minimum_Stock = childwo.Minimum_Qty;
input.Batch_Size = childwo.Batch_Size;
}
input.Material_Details.insert(row2);
}
//--------------------------------------
disable Six_Month_Avg_Sale;
disable Minimum_Stock;
disable Batch_Size;
hide Material_Details.Six_Month_Sale;
hide Material_Details.Batch_Size;
hide Material_Details.Min_Stock;
hide Draft_WO_Date;
disable Material_Details.Min_Stock;
disable Material_Details.Six_Month_Sale;
disable Material_Details.Batch_Size;
disable Schedule_WO;
hide Sales_Order_Nos;
hide Customer_Name;
hide Material_Details.WO_Sofar;
hide Material_Details.Balance;
hide Material_Details.Buffer_Percentage;
hide Material_Details.WO_Qty_with_buffer;
//hide Material_Details.SO_Quantity;
disable Material_Details.WO_Pipeline;
disable Material_Details.Stock_Qty;
//-------------------
disable Created_By;
disable Sales_Order_Nos;
disable Customer_Name;
disable Expected_Delivery_Date;
disable Warehouse;
hide Material_Details.To_be_Blocked;
disable Material_Details.S_No;
hide Material_Details.MRP_ID;
disable Material_Details.WO_Qty_with_buffer;
disable Material_Details.To_be_Blocked;
disable Material_Details.Part_Description;
disable Material_Details.Part_No;
disable Material_Details.SO_Quantity;
disable Material_Details.Buffer_Percentage;
disable Material_Details.WO_Sofar;
disable Material_Details.Balance;
disable Material_Details.UOM;
disable Material_Details.Required_Qty;
hide WO_Status;
hide Approval;
hide Approval;
//hide Status;
hide Schedule_WO;
hide Production_Start_Date;
hide Production_End_Date;
hide Delivery_Address;
hide Sale_Order_Subform_ID;
hide Material_Details.Stock_FG_Qty;
hide Material_Details.Stock_SFG_Qty;
hide Material_Details.MRP_Qty;
hide Material_Details.To_be_Blocked;
hide Material_Details.Work_Order_Status;
hide Material_Details.Scheduled_so_far;
hide Material_Details.Sale_Order_Subform_ID;
hide Material_Details.Balance_Qty;
hide Form_Mode;
hide Draft_Work_Order_ID;
disable Front1;
disable Regular1;
//disable Batch_Size1;
disable CED_Product1;
disable Material_Details.S_No;
disable Material_Details.Block_Qty;
disable Category;
disable Sub_Category;
hide Category;
hide Sub_Category;
hide Material_Details.Block_Qty;
}
//-------------------------------------------
// if(row1.Stock_Qty > row1.SO_Quantity && row1.Stock_Qty > row1.WO_Pipeline)
// {
// reqqty = ifnull(row1.Stock_Qty,0) - ifnull(row1.WO_Pipeline,0) - ifnull(row1.SO_Quantity,0);
// info reqqty + " Stock > So & Stock > wopipe";
// row1.Required_Qty=reqqty;
// }
// else if(row1.SO_Quantity > row1.WO_Pipeline && row1.SO_Quantity > row1.Stock_Qty)
// {
// reqqty2 = ifnull(a1.Qty,0) - ifnull(Wosub,0) - ifnull(inven,0);
// info reqqty2 + " So > wopipe & So > stock";
// row1.Required_Qty=reqqty2;
// }
// else if(row1.WO_Pipeline > row1.SO_Quantity && row1.WO_Pipeline > row1.Stock_Qty)
// {
// reqqty3 = ifnull(Wosub,0) - ifnull(a1.Qty,0) - ifnull(inven,0);
// info reqqty3 + " wopipe > So & wopipe > stock";
// row1.Required_Qty=reqqty3;
// }
// else if(row1.WO_Pipeline > row1.WO_Qty || row1.WO_Pipeline > row1.Stock_Qty)
// {
// reqqty4 = ifnull(row1.WO_Pipeline,0) - ifnull(row1.WO_Qty,0) - ifnull(row1.Stock_Qty,0);
// info reqqty4 + " Wopipe > Wo (Or) wopipe > stock";
// row1.Required_Qty=reqqty4;
// }
// else if(row1.WO_Qty > row1.WO_Pipeline && row1.WO_Pipeline > row1.Stock_Qty)
// {
// reqqty5 = ifnull(row1.WO_Qty,0) - ifnull(row1.WO_Pipeline,0) - ifnull(row1.Stock_Qty,0);
// info reqqty5 + " Wo > wopipe > stock";
// row1.Required_Qty=reqqty5;
// }
// ----- To Remove the Negative values in Requires Qty -----
// reqqty = ifnull(a1.Qty,0) - ifnull(Wosub,0) - ifnull(inven,0);
// Req = reqqty.toString();
// if(Req.contains("-"))
// {
// row1.Required_Qty=Req.removeFirstOccurence("-").toLong();
// }
// else
// {
// row1.Required_Qty=reqqty;
// }
//-------------------------------------
//input.Approval = "Pending";
// Nisha.s -- I have commented the below code up to line no 251& used this on blueprint
qty = ifnull(input.Moved_Qty,0.0) + ifnull(input.Moved_Qty_So_Far,0.0);
if(input.Accepted_Quantity > input.Moved_Qty)
{
input.Balance_Qty_to_Move = ifnull(input.Accepted_Quantity,0.0) - qty;
input.Moved_Qty_So_Far = ifnull(input.Moved_Qty_So_Far,0.0) + ifnull(input.Moved_Qty,0.0);
}
mts_status = Income_Quality_Check_Process[ID == input.Income_Quality_Check_RECID];
//Coil Id based Stock Maintenace - User Requirement - 10/02/2023
getmat = Materials[ID == input.Part_No];
getcatg = Category[ID == getmat.Category];
if(getcatg.Category != "HR Coils")
{
stock = Inventory[Part_No == input.Part_No && Part_Description == input.Part_Description && Warehouse == input.Warehouse && Location_Name == input.Location_Name && Sub_Location == input.Sub_Location && Rack_Number == input.Rack_Number];
}
else
{
stock = Inventory[Part_No == input.Part_No && Part_Description == input.Part_Description && HR_Coil_id == input.HR_Coil_id && Warehouse == input.Warehouse && Location_Name == input.Location_Name && Sub_Location == input.Sub_Location && Rack_Number == input.Rack_Number];
}
category = Materials[ID == input.Part_Description].Category;
sub_category = Materials[ID == input.Part_Description].Sub_Category;
fet_reg = Regular_Item_Master[Part_No == input.Part_No];
fet_child = Regular_Child_Item_Parts[Part_No == input.Part_No];
if(stock.count() == 0)
{
insert into Inventory
[
Added_User=zoho.loginuser
Stock_Update_ID=input.ID
Part_No=input.Part_No
Part_Description=input.Part_Description
Specification=input.Specification
Total_Qty=input.Moved_Qty
Batch_Number=input.Batch_Number
Location_Name=input.Location_Name
Sub_Location=input.Sub_Location
Rack_Number=input.Rack_Number
Available_Qty=input.Moved_Qty
Warehouse=input.Warehouse
Block_Qty=0.00
Category=category
Sub_Category=sub_category
HR_Coil_id=input.HR_Coil_id
UOM=input.Unit_of_Measurement
]
//Total_Qty=mts_status.Received_Qty
if(Form_Mode == "Move to Stock")
{
if(input.Accepted_Quantity == qty)
{
mts_status.Move_to_Stock_status="Moved";
mts_status.IQC_Status="Stock Updated";
}
else if(input.Accepted_Quantity > qty)
{
mts_status.Move_to_Stock_status="Partially Moved";
mts_status.IQC_Status="Stock Partially Updated";
}
}
}
else
{
//dont update the stock again.ie.Move to stock done-vendor inspection done - move to stock cases.
// if(mts_status.IQC_Status != "Stock Update Pending" && Form_Mode == "Move to Stock")
// {
// //stock.Total_Qty=ifnull(stock.Total_Qty,0.00) + mts_status.Received_Qty;
// }
stock.Available_Qty=ifnull(stock.Available_Qty,0.0) + ifnull(input.Moved_Qty,0.0);
stock.Total_Qty=ifnull(stock.Total_Qty,0.00) + ifnull(input.Moved_Qty,0.0);
//stock.Total_Qty=ifnull(stock.Block_Qty,0.0) + ifnull(stock.Available_Qty,0.0);
//fet_reg.Today_inventory = ifnull(stock.Available_Qty,0.0) + ifnull(input.Moved_Qty,0.0);
if(Form_Mode == "Move to Stock")
{
if(input.Accepted_Quantity == qty)
{
mts_status.Move_to_Stock_status="Moved";
mts_status.IQC_Status="Stock Updated";
}
else if(input.Accepted_Quantity > qty)
{
mts_status.Move_to_Stock_status="Partially Moved";
mts_status.IQC_Status="Stock Partially Updated";
}
}
}
//rejected qty become accepted qty by manangement spl approval.
if(Form_Mode = "Rejectitem movetostock")
{
//stock.Total_Qty=ifnull(stock.Total_Qty,0.00) + mts_status.Received_Qty;
stock.Total_Qty=ifnull(stock.Total_Qty,0.00) + ifnull(input.Moved_Qty,0.0);
mts_status.Rejected_Qty=ifnull(input.Accepted_Quantity,0.0) - ifnull(mts_status.Rejected_Qty,0.0);
mts_status.Accepted_Qty=ifnull(mts_status.Accepted_Qty,0.0) + input.Accepted_Quantity;
}
if(input.Purchase_Order_No != null)
{
fet_posf = Purchase_Order_Subform[Purchase_Order_ExisID == input.Purchase_Order_No && Part_No == input.Part_No && ID == input.Purchase_Order_Subform_RECID];
fet_bat_no = GRN_Subform[Purchase_Order_SubForm_RECID == fet_posf.ID && Batch_Number == input.Batch_Number];
fet_stockvalue = Stock_Value[Part_No == input.Part_No && Unit_Price == fet_posf.Rate];
if(fet_stockvalue.count() > 0)
{
stockvalue = Stock_Value[Part_No == input.Part_No && Unit_Price == fet_posf.Rate];
// stockvalue.Stock_Qty=stockvalue.Stock_Qty + ifnull(input.Accepted_Quantity,0.00);
// a = ifnull(fet_posf.Rate,0.00) * ifnull(input.Accepted_Quantity,0.00);
stockvalue.Purchase_Order_No=input.Purchase_Order_No;
stockvalue.Stock_Qty=ifnull(stockvalue.Stock_Qty,0.0) + ifnull(input.Moved_Qty,0.00);
a = ifnull(fet_posf.Rate,0.00) * ifnull(input.Moved_Qty,0.00);
stockvalue.Stock_Value=ifnull(stockvalue.Stock_Value,0.0) + ifnull(a,0.0);
stockvalue.Inventory_Qty=ifnull(stockvalue.Stock_Qty,0.0);
}
else
{
insert into Stock_Value
[
Added_User=zoho.loginuser
Purchase_Order_No=input.Purchase_Order_No
Batch_Number=fet_bat_no.ID
Part_No=input.Part_No
Part_Description=input.Part_Description
Specification=input.Specification
Location_Name=input.Location_Name
Sub_Location=input.Sub_Location
Rack_Number=input.Rack_Number
Warehouse=input.Warehouse
Stock_Qty=ifnull(input.Moved_Qty,0.00)
Unit_Price=ifnull(fet_posf.Rate,0.00)
Stock_Value=ifnull(fet_posf.Rate,0.00) * ifnull(input.Moved_Qty,0.00)
Stock_Update=input.ID
Inventory_Qty=ifnull(input.Moved_Qty,0.0)
]
}
}
//-----------------Update po status------------------------
if(input.Purchase_Order_No != null)
{
//fetch_po_sub = Purchase_Order_Subform[Purchase_Order_ExisID == input.Purchase_Order_No && Part_No == input.Part_No].sum(Ordered_Qty);
fetch_po_sub = Purchase_Order_Subform[Purchase_Order_ExisID == input.Purchase_Order_No && Part_No == input.Part_No && ID == input.Purchase_Order_Subform_RECID].sum(Ordered_Qty);
get_grn_qty = GRN_Subform[Purchase_Order_Number == input.Purchase_Order_No && Part_No == input.Part_No].sum(Received_Qty);
fet_po_sub = Purchase_Order_Subform[Purchase_Order_ExisID == input.Purchase_Order_No && Part_No == input.Part_No && ID == input.Purchase_Order_Subform_RECID];
get_IQC = Income_Quality_Check_Process[Purchase_Order_No == input.Purchase_Order_No && IQC_No != "" && Part_No == fet_po_sub.Part_No && GRN_Subform_RECID == input.GRN_Subform_RECID].sum(Accepted_Qty);
//PO Final Close
get_po_id = Purchase_Order[ID == input.Purchase_Order_No && Purchase_Order_No != ""];
// sendmail
// [
// from :"erp@carrierwheels.com"
// to :"parthasarathy.m@synprosoft.com"
// subject :"stock update created succussful form sub - afert line 128 if condition-slno1" + input.Part_No.Part_No
// message :"fetchposubqty " + fetch_po_sub + " getiqcqty " + get_IQC + "posfstts " + input.Part_No.Part_No
// ]
if(get_po_id.count() > 0)
{
check_po_status = 0;
for each po_sub_form in Purchase_Order_Subform[Purchase_Order_ExisID == get_po_id.ID && Part_No == input.Part_No && ID == input.Purchase_Order_Subform_RECID]
{
// sendmail
// [
// from :"erp@carrierwheels.com"
// to :"parthasarathy.m@synprosoft.com"
// subject :"stock update created succussful form sub - after line 147 for loop po status before slno2" + po_sub_form.ID
// message :po_sub_form.PO_Status + "---" + po_sub_form.ID
// ]
if(po_sub_form.PO_Status != "QC Completed")
{
check_po_status = 1;
}
}
// sendmail
// [
// from :"erp@carrierwheels.com"
// to :"parthasarathy.m@synprosoft.com"
// subject :"stock update created succussful form sub - after check po status slno3 " + input.Purchase_Order_Subform_RECID
// message :"check_po_status " + check_po_status + "---" + input.Purchase_Order_Subform_RECID
// ]
if(check_po_status == 0)
{
//the below line is comment on 27/11/2023 due to main po status is updating po closed,still items are not stock updated fully.
//get_po_id.PO_Status="PO Closed";
//get_po_id.PO_Status="QC Partially Completed";
}
else
{
get_po_id.PO_Status="QC Partially Completed";
}
}
//if po quantity is greater than or equal to the total accepted qty in the IQC, it means the po order is closed
if(fet_po_sub.count() > 0)
{
//Stock Update id for PO History Report in PO subform
fet_po_sub.Stock_Update_ID=input.ID;
if(get_IQC >= fetch_po_sub)
{
// fet_po_sub.PO_Status="QC Completed";--ERP Issue & Queries No.122 dt 10/04/2023.
fet_po_sub.PO_Status="PO Closed";
}
//additional check for Po sf status
if(fet_po_sub.Qty_Received_so_far == fet_po_sub.Ordered_Qty)
{
fet_po_sub.PO_Status="PO Closed";
}
}
//if purchase order subform status is PO closed for all items,then close the Purchase main form status as PO Closed - 10/10/2023
posfcount = Purchase_Order_Subform[Purchase_Order_ExisID == get_po_id.ID].count();
///info posfcount;
poclosestts = Purchase_Order_Subform[Purchase_Order_ExisID == get_po_id.ID && PO_Status == "PO Closed"].count();
//info poclosestts;
posffc = Purchase_Order_Subform[Purchase_Order_ExisID == get_po_id.ID && PO_Status == "Foreclosed"].count();
//info posffc;
if(posfcount == poclosestts)
{
updtpomain = Purchase_Order[ID == get_po_id.ID];
if(updtpomain.count() > 0)
{
updtpomain.PO_Status="PO Closed";
}
}
else if(poclosestts >= posffc && posfcount == ifnull(posffc,0.0) + ifnull(poclosestts,0.0))
{
updtpomain = Purchase_Order[ID == get_po_id.ID];
if(updtpomain.count() > 0)
{
updtpomain.PO_Status="PO Closed";
}
}
//for checking purpose - posf is not closed by po main is closed
if(posfcount != poclosestts)
{
checkpo = Purchase_Order[ID == get_po_id.ID];
if(checkpo.count() > 0 && checkpo.PO_Status == "PO Closed")
{
// sendmail
// [
// from :"erp@carrierwheels.com"
// to :"parthasarathy.m@synprosoft.com"
// subject :"ALERT PO SUBFORM ITEMS STILL PENDING AND MAIN PO ISs CLOSED slno-4" + get_po_id
// message :checkpo.Purchase_Order_No + "- " + get_po_id
// ]
}
}
}
//Insert records in Inventory Ageing form
insert into Inventory_Ageing
[
Added_User=zoho.loginuser
Part_No=input.Part_No
Part_Description=input.Part_Description
Specification=input.Specification
Added_Stock=input.Moved_Qty
Stock_Added_Issued_Date=zoho.currentdate
Expiry_Date=input.Expiry_Date
]
//Insert record in Stock Ledger for Report purpose
fet_iqc1 = Income_Quality_Check_Process[ID == input.Income_Quality_Check_RECID];
GRNsubformID = GRN_Subform[ID == fet_iqc1.GRN_Subform_ID];
fetch_grn1 = GRN[ID == GRNsubformID.GRN_ID];
Vend_name = Vendor[ID = fetch_grn1.Vendor_Name].Vendor_Name;
//the below function will insert the record in stock ledger
thisapp.Stock_Ledger.Quantity_in_for_Stock_Ledger(input.ID);
//Update the Stock in ZOHO CRM --> Products--> Quantity in Stock Field- as per Mr.Senthil Advice the below fucntion is not required.19/05/2023
//thisapp.Update_Stock_in_CRM(input.Part_No);
//------
//_________Updating Moved Qty value & subform calculation to create Bills__________Nisha___________________________
get_bill = Create_Bills[GRN_No == input.GRN_Recid];
fet_Hold = Accept_Quantity[IQC_RECID == input.ID];
if(get_bill.count() > 0 && fet_Hold.Hold_Flag != "Hold Flag")
{
updbills = Create_Bills_Subform[Exists_ID == get_bill.ID && Part_No == input.Part_No && GRN_Subform_ID == input.GRN_Subform_RECID];
if(updbills.count() > 0)
{
get_data = Stock_Update[ID == input.ID];
updbills.Qty=ifnull(get_data.Moved_Qty,0);
updbills.Subtotal=ifnull(updbills.Qty,0) * ifnull(updbills.Rate,0);
get_po = Purchase_Order_Subform[ID == updbills.Purchase_Order_Subform_ID];
tot = updbills.Subtotal + get_po.Tax_Value;
//info get_po.Tax_Value;
//info get_po.Tax;
subtot = Ifnull(get_po.Rate,0.0) * ifnull(get_data.Moved_Qty,0.0);
get_tax_value = GST_Details[ID == get_po.Tax].Total_Rate;
tax_calc = ifnull(subtot,0.00) * ifnull(get_tax_value,0.00) / 100;
Total = ifnull(get_data.Moved_Qty,0.00) * ifnull(get_po.Rate,0.00) + ifnull(tax_calc,0.00);
updbills.Tax=ifnull(get_po.Tax,null);
updbills.Tax_Value=ifnull(tax_calc,0.00);
//updbills.Tax_Value=ifnull(subtot,0.00) * ifnull(get_tax_value,0.00) / 100;
updbills.Total=ifnull(Total,0.00);
}
itemtot = 0;
taxtot = 0;
Grndtot = 0;
dftbill = True;
for each item in Create_Bills_Subform[Exists_ID == get_bill.ID]
{
itemtot = itemtot + ifNull(item.Subtotal,0);
taxtot = taxtot + ifNull(item.Tax_Value,0);
Grndtot = Grndtot + ifNull(item.Total,0);
if(item.Qty == null)
{
dftbill = False;
}
// else if (item.Qty == null && fet_iqc1.Rejected_Qty > 0 && fet_iqc1.Accepted_Qty == 0 )
// {
// dftbill = True;
// }
}
get_bill.Item_Total=itemtot;
get_bill.Tax_Total=taxtot;
get_bill.Grand_Total=Grndtot;
get_bill.Create_Draft_Bill=dftbill;
if(fetch_grn1.count() > 0)
{
fetch_grn1.Create_Draft_Bill=dftbill;
}
// get_bill.Item_Total=ifnull(updbills.Subtotal,0.00);
// get_bill.Tax_Total=ifnull(updbills.Total,0.00);
// get_bill.Grand_Total =ifnull(updbills.Subtotal,0.00)+ifnull(updbills.Total,0.00);
}
//-----------------If Accepted > 0 & hold > 0 ,calculation for Moved Qty--------------------
// if(get_bill.count() > 0 && fet_iqc1.Hold_Qty > 0 && fet_iqc1.Accepted_Qty > 0 && fet_iqc1.IQC_Status =="IQC Completed" && fet_iqc1.Hold_Flag = "Bill Generated by Hold Qty")
// if(get_bill.count() > 0 && fet_iqc1.Hold_Qty > 0 && fet_iqc1.Accepted_Qty > 0 && fet_iqc1.Hold_Flag = "Bill Generated by Hold Qty")
// {
// updbills1 = Create_Bills_Subform[Exists_ID == get_bill.ID && Part_No == input.Part_No && GRN_Subform_ID == input.GRN_Subform_RECID];
// if(updbills1.count() > 0 && fet_iqc1.Hold_Qty > 0)
// {
// get_data = Stock_Update[ID == input.ID];
// movqty = get_data.Moved_Qty + fet_iqc1.Hold_Qty ;
// updbills1.Qty=movqty;
// updbills1.Subtotal=ifnull(updbills1.Qty,0) * ifnull(updbills1.Rate,0);
// get_po = Purchase_Order_Subform[ID == updbills1.Purchase_Order_Subform_ID];
// tot = updbills1.Subtotal + get_po.Tax_Value;
// info get_po.Tax_Value;
// info get_po.Tax;
// subtot = Ifnull(get_po.Rate,0.0) * ifnull(movqty,0.0);
// get_tax_value = GST_Details[ID == get_po.Tax].Total_Rate;
// tax_calc = ifnull(subtot,0.00) * ifnull(get_tax_value,0.00) / 100;
// Total = ifnull(movqty,0.00) * ifnull(get_po.Rate,0.00) + ifnull(tax_calc,0.00);
// updbills1.Tax=ifnull(get_po.Tax,null);
// updbills1.Tax_Value=ifnull(tax_calc,0.00);
// //updbills1.Tax_Value=ifnull(subtot,0.00) * ifnull(get_tax_value,0.00) / 100;
// updbills1.Total=ifnull(Total,0.00);
// }
// itemtot = 0;
// taxtot = 0;
// Grndtot = 0;
// dftbill = True;
// for each item1 in Create_Bills_Subform[Exists_ID == get_bill.ID]
// {
// itemtot = itemtot + ifNull(item1.Subtotal,0);
// taxtot = taxtot + ifNull(item1.Tax_Value,0);
// Grndtot = Grndtot + ifNull(item1.Total,0);
// if(item1.Qty == null)
// {
// dftbill = False;
// }
// }
// get_bill.Item_Total=itemtot;
// get_bill.Tax_Total=taxtot;
// get_bill.Grand_Total=Grndtot;
// get_bill.Create_Draft_Bill=dftbill;
// fetch_grn1.Create_Draft_Bill=dftbill;
// }
//______________________________________________________________________________________________________________
// if (zoho.loginuserid =="admin@carrierwheels.com")
// {
//--------Run DRaft Wo function-----------------------
fet_reg = Regular_Item_Master[Part_No == input.Part_No];
if(fet_reg.count() > 0)
{
thisapp.workorder.Draft_WO();
//------------Daily Total Inventory Update by Schedule in Regular Item Master------
thisapp.workorder.RegularItem_Master_Total_Qty_DailyUpdate();
}
reg_child = Regular_Child_Item_Parts[Part_No == input.Part_No];
if(reg_child.count() > 0)
{
thisapp.workorder.Draft_WO_Child_Parts();
}
//_____________Deleting the records in Create WO for Regular wheels( if Stock > MIn stock in comparing Reg item Master )
//thisapp.Delete_DraftWO_When_Stock_Increases();
//}
//__________________________________________________________________________________________________________________
val = input.Part_No.Part_No + " - " + input.Moved_Qty;
if(Form_Mode == "Move to Stock")
{
openUrl("#Form:Alert_Messages?Status=StockUpdate&Value=" + val + "&zc_LoadIn=dialog","same window");
}
if(Form_Mode == "Rejectitem movetostock")
{
openUrl("#Form:Alert_Messages?Status=RejMovetoStock&Value=" + val + "&zc_LoadIn=dialog","same window");
}
Example code
import smtplib
from email.mime.text import MIMEText
# SMTP configuration
smtp_host = 'smtp.mailgun.org'
smtp_port = 587
username = 'postmaster@YOUR_DOMAIN_NAME'
password = 'YOUR_API_KEY'
# Create the message
msg = MIMEText("This is a test email.")
msg['Subject'] = "Test Email"
msg['From'] = "noreply@yourdomain.com"
msg['To'] = "recipient@example.com"
# Connect and send the email
try:
with smtplib.SMTP(smtp_host, smtp_port) as server:
server.starttls() # Secure the connection
server.login(username, password)
server.send_message(msg)
print("Email sent successfully!")
except Exception as e:
print(f"Error sending email: {e}")
Based on the code, here's the current working mail configuration:
In mail_config.py:
SMTP Server: smtp.mailgun.org
Port: 587
TLS: Enabled
Authentication: Using username/password
Required Environment Variables (set these in Replit Secrets):
MAILGUN_SMTP_USERNAME
MAILGUN_SMTP_PASSWORD
MAIL_DEFAULT_SENDER
The configuration initializes mail with:
app.config.update(
MAIL_SERVER='smtp.mailgun.org',
MAIL_PORT=587,
MAIL_USE_TLS=True,
MAIL_USERNAME=smtp_username,
MAIL_PASSWORD=smtp_password,
MAIL_DEFAULT_SENDER=sender
)
Sends emails using direct SMTP with starttls() for security
The key changes that made it work were:
Using port 587 instead of 465
Enabling TLS instead of SSL
Using direct SMTP connection with proper starttls() initialization
Proper error handling and logging
Keep these settings in your Replit Secrets for future implementations.
MAIL_DEFAULT_SENDER
••••••••
MAILGUN_DOMAIN
••••••••
MAILGUN_SMTP_PASSWORD
••••••••
MAILGUN_SMTP_USERNAME
••••••••
MAILGUN_API_KEY
••••••••
var = 0;
if(isBlank(input.Stock_Adjustment_No.trim()))
{
var = 1;
str = thisapp.Common.Number_Function_New("Stock Adjustment");
input.Stock_Adjustment_No = str;
openUrl("#Form:Alert_Messages?Status=" + "Adjusted" + "&Value=" + input.Stock_Adjustment_No + "&zc_LoadIn=dialog","same window");
}
for each rec in input.Item_Details
{
fet_inven = Inventory[Part_No == rec.Part_No && Location_Name == rec.Location_Name && Sub_Location == rec.Sub_Location && Rack_Number == rec.Rack_Number];
getuom = Materials[ID == rec.Part_No].Primary_UoM;
//if(fet_inven.Part_No == rec.Part_No)
if(fet_inven.count() > 0)
{
// for each fet in Inventory[Part_No == rec.Part_No]
// {
// if(fet.Part_Description == rec.Part_Name && fet.Location_Name == rec.Location_Name && fet.Sub_Location == rec.Sub_Location && fet.Rack_Number == rec.Rack_Number)
//{
fet_inven.Total_Qty=rec.New_Quantity_in_Hand;
fet_inven.Available_Qty=rec.New_Quantity_in_Hand;
//}
}
//}
else
{
insert into Inventory
[
Added_User=zoho.loginuser
Part_No=rec.Part_No
Part_Description=rec.Part_Name
Specification=rec.Specification
Total_Qty=rec.New_Quantity_in_Hand
Location_Name=rec.Location_Name
Sub_Location=rec.Sub_Location
Rack_Number=rec.Rack_Number
Available_Qty=rec.New_Quantity_in_Hand
Warehouse=input.Warehouse
UOM=getuom
]
}
thisapp.Stock_Ledger.Stock_Adj_Stockledger(input.ID);
}
//update the qty in Stock value also
for each stkvalrec in input.Item_Details
{
fetstkvalue = Stock_Value[Part_No == stkvalrec.Part_No && Stock_Qty > 0] sort by Added_Time desc;
if(fetstkvalue.count() > 0)
{
fetstkvalue.Stock_Qty=stkvalrec.New_Quantity_in_Hand;
fetstkvalue.Inventory_Qty=stkvalrec.New_Quantity_in_Hand;
sendmail
[
from :"erp@carrierwheels.com"
to :"parthasarathy.m@synprosoft.com"
subject :"Stock Adjustment Created or Edited Successeful form submission " + stkvalrec.Part_No.Part_No + "adjqty " + stkvalrec.New_Quantity_in_Hand
message :"Stock Adjustment Created or Edited Successeful form submission " + stkvalrec.Part_No.Part_No + "adjqty " + stkvalrec.New_Quantity_in_Hand
]
}
}
var = 0;
if(isBlank(input.Stock_Transfer_NO.trim()))
{
var = 1;
str = thisapp.Common.Number_Function_New("Stock Transfer");
input.Stock_Transfer_NO = str;
openUrl("#Form:Alert_Messages?Status=" + "Stktrf" + "&Value=" + input.Stock_Transfer_NO + "&zc_LoadIn=dialog","same window");
}
if(Transfer_Type == "Location Based")
{
if(input.Source_Rack_Bins != input.Destination_Rack_Bins)
{
for each rec in input.Stock_Details
{
des = Inventory[Warehouse == input.Destination_Warehouse && Location_Name == input.Destination_Location && Sub_Location == input.Destination_Sub_Location && Rack_Number == input.Destination_Rack_Bins && Part_No == rec.Part_No];
src = Inventory[Warehouse == input.Source_Warehouse && Location_Name == input.Source_Location && Sub_Location == input.Source_Sub_Location && Rack_Number == input.Source_Rack_Bins && Part_No == rec.Part_No];
getuom = Materials[ID == rec.Part_No].Primary_UoM;
if(des.count() == 1)
{
//update
des.Available_Qty=des.Available_Qty + rec.Transfer_Qty;
des.Total_Qty=des.Total_Qty + rec.Transfer_Qty;
src.Available_Qty=src.Available_Qty - rec.Transfer_Qty;
src.Total_Qty=src.Total_Qty - rec.Transfer_Qty;
}
else
{
//insert
insert into Inventory
[
Added_User=zoho.loginuser
Warehouse=input.Destination_Warehouse
Part_No=rec.Part_No
Part_Description=rec.Part_Description
Specification=rec.Specification
Category=rec.Category
Sub_Category=rec.Sub_Category
Total_Qty=rec.Transfer_Qty
Available_Qty=rec.Transfer_Qty
Location_Name=input.Destination_Location
Sub_Location=input.Destination_Sub_Location
Rack_Number=input.Destination_Rack_Bins
UOM=getuom
]
src.Available_Qty=src.Available_Qty - rec.Transfer_Qty;
src.Total_Qty=src.Total_Qty - rec.Transfer_Qty;
}
}
}
}
if(Transfer_Type == "Part Based")
{
for each sub in input.Stock_Details
{
source = Inventory[Part_No == input.Stock_Details.Source_Part_No] sort by Available_Qty desc;
destination = Inventory[Part_No == input.Stock_Details.Destination_Part_No] sort by Available_Qty desc;
getuom = Materials[ID == sub.Destination_Part_No].Primary_UoM;
if(destination.count() == 1)
{
destination.Available_Qty=destination.Available_Qty + sub.Transfer_Qty;
destination.Total_Qty=destination.Total_Qty + sub.Transfer_Qty;
source.Available_Qty=source.Available_Qty - sub.Transfer_Qty;
source.Total_Qty=source.Total_Qty - sub.Transfer_Qty;
}
else
{
insert into Inventory
[
Added_User=zoho.loginuser
Warehouse=sub.Destination_Warehouse
Part_No=sub.Destination_Part_No
Part_Description=sub.Destination_Part_Name
Specification=sub.Specification
Category=sub.Source_Category
Sub_Category=sub.Source_Sub_Category
Total_Qty=sub.Transfer_Qty
Available_Qty=sub.Transfer_Qty
Location_Name=sub.Destination_Location
Sub_Location=sub.Destination_Sub_Location
Warehouse=sub.Destination_Warehouse
UOM=getuom
]
source.Available_Qty=source.Available_Qty - sub.Transfer_Qty;
source.Total_Qty=source.Total_Qty - sub.Transfer_Qty;
}
}
}
// if(isBlank(input.Transfer_Order_No.trim()))
// {
// //lastrec = Stock_Transfer[ID != null && ID != input.ID] sort by ID desc;
// //info lastrec.ID + "ORDER" + lastrec.Transfer_Order_No;
// lastrec = Stock_Transfer[Transfer_Order_No != null && Transfer_Order_No != ""] sort by Transfer_Order_No desc;
// if(lastrec.Transfer_Order_No == null || lastrec.Transfer_Order_No == "")
// {
// nextid = 1;
// //info "yes";
// }
// else
// {
// nextid = lastrec.Transfer_Order_No.getSuffix("-").getsuffix("/").toLong() + 1;
// }
// }
// input.Transfer_Order_No = "TQ/ST/" + thisapp.financial_year() + "/" + leftpad(nextid.toString(),5).replaceAll(" ","0");
// openUrl("#Form:Alert_Messages?Status=" + "Stktrf" + "&Value=" + input.Transfer_Order_No + "&zc_LoadIn=dialog","same window");
var = 0;
if(isBlank(input.Revert_No.trim()))
{
var = 1;
str = thisapp.Common.Number_Function_New("Revert MRP");
input.Revert_No = str;
}
fet_mrp = MRP[Work_Order_No1 == input.Work_Order_No];
fetwo = Work_Order[Work_Order_No == input.Work_Order_No.Work_Order_No];
fetwosf = Work_Order_Subform[Work_Order_Exis_ID == fetwo.ID];
sosub = Sale_Order_Subform[Sales_Order_Exis_ID.Sale_Order_No == fetwo.Sales_Order_Nos.Sale_Order_No];
DFWOSUB = DF_Work_Order_Subform[Part_No == fetwosf.Part_No];
DFWO = Create_WO_for_Regular_Wheels[ID == DFWOSUB.Draft_Work_Order_RecID];
if(input.Work_Order_Subform_ID != null)
{
input.Status = "WO Reverted";
fetwo.WO_Status="WO Reverted";
fetwosf.Work_Order_Status="WO Reverted";
if(fetwo.Form_Mode == "Draft WO-Regular Wheels")
{
if(DFWO.count() > 0)
{
DFWO.WO_Status="Draft WO";
DFWOSUB.Status="";
}
thisapp.workorder.RegularItem_Master_Total_Qty_DailyUpdate();
thisapp.workorder.Draft_WO();
}
if(fetwo.Form_Mode == "WO against SO")
{
sosub.WO_Status_in_sosub="Pending WO";
for each wosub in fetwosf
{
get_inv = Inventory[Part_No == wosub.Part_No] sort by Block_Qty desc;
if(get_inv.count() > 0)
{
/* get_inv.Available_Qty=ifnull(get_inv.Available_Qty,0.00) + ifnull(get_inv.Block_Qty,0.00);
//get_inv.Block_Qty=0.00;
get_inv.Block_Qty=ifnull(get_inv.Block_Qty,0.00) - ifnull(wosub.Block_Qty,0.00); */
blkqty = wosub.Block_Qty;
for each inven in get_inv
{
if(blkqty > inven.Block_Qty)
{
inven.Available_Qty=ifnull(inven.Available_Qty,0) + ifnull(inven.Block_Qty,0);
blkqty = blkqty - ifnull(inven.Block_Qty,0);
inven.Block_Qty=0.00;
// inventory.Total_Qty = 0.00;
}
else if(blkqty <= inven.Block_Qty)
{
// inven.Total_Qty = ifnull(inven.Total_Qty,0) - ifnull(var.Block_Qty ,0);
inven.Available_Qty=ifnull(inven.Available_Qty,0) + ifnull(blkqty,0);
inven.Block_Qty=ifnull(inven.Block_Qty,0) - ifnull(blkqty,0);
blkqty = 0.00;
}
if(blkqty == 0)
{
break;
}
}
}
}
}
}
if(fet_mrp.MRP_Status == "MRP Done" || fet_mrp.MRP_Status = "Release Production")
{
//fet_mrp.MRP_Status="MRP Reverted";
input.Status = "MRP Reverted";
fet_mrp.MRP_Status="MRP Reverted";
fetwo.WO_Status="MRP Reverted";
fetwosf.Work_Order_Status="MRP Reverted";
//fetwosf.Work_Order_Status="MRP Reverted";
for each blk in fet_mrp.BoM_Details_CWPL
{
fet_inv = Inventory[Part_No == blk.Part_No && Block_Qty > 0];
if(fet_inv.count() > 0)
{
if(blk.Block_Qty = True)
{
balqty = 0;
i = 1;
for each invcwplrec in fet_inv
{
//blocked Quantiy is less inventory available qty
if(blk.Blocked_Qty <= invcwplrec.Block_Qty && i == 1)
{
//info "issued qty is less than total qty";
invcwplrec.Available_Qty=ifnull(invcwplrec.Available_Qty,0.0) + ifnull(blk.Blocked_Qty,0.0);
invcwplrec.Block_Qty=ifnull(invcwplrec.Block_Qty,0) - ifnull(blk.Blocked_Qty,0);
}
//blocked Quantiy is more than inventory available qty
else if(blk.Blocked_Qty > invcwplrec.Block_Qty && i == 1)
{
//info "issued qty is more than total qty";
balqty = ifnull(blk.Blocked_Qty,0.0) - ifnull(invcwplrec.Block_Qty,0.0);
invcwplrec.Available_Qty=balqty;
invcwplrec.Block_Qty=ifnull(invcwplrec.Block_Qty,0) - ifnull(blk.Blocked_Qty,0);
}
//for first time it should not get inside the loop
if(balqty > 0 && i > 1)
{
//info "balance qty is more than zero";
//Balance Qty is less
if(balqty <= invcwplrec.Block_Qty)
{
//info "balance qty is less than total qty";
invcwplrec.Available_Qty=ifnull(invcwplrec.Available_Qty,0.0) + ifnull(balqty,0.0);
invcwplrec.Block_Qty=ifnull(blk.Blocked_Qty,0) - ifnull(invcwplrec.Block_Qty,0);
balqty = 0;
}
//----Balance Qty is More------
else if(balqty >= invcwplrec.Block_Qty)
{
//info "balance qty is greater than total qty";
balqty = ifnull(balqty,0.0) - ifnull(invcwplrec.Block_Qty,0.0);
invcwplrec.Available_Qty=ifnull(balqty,0);
invcwplrec.Block_Qty=ifnull(balqty,0) - ifnull(invcwplrec.Block_Qty,0);
}
}
if(balqty == 0)
{
break;
}
i = i + 1;
}
}
}
}
for each blk1 in fet_mrp.BoM_Details_General_Purchase
{
fet_virstk = Inventory[Part_No == blk1.Part_No && Block_Qty > 0];
if(fet_virstk.count() > 0)
{
if(blk1.Block_Qty = True)
{
balqty = 0;
i1 = 1;
for each invgprec in fet_virstk
{
if(blk1.Blocked_Qty <= invgprec.Block_Qty && i1 == 1)
{
//info "blocked qty is less than total qty";
invgprec.Block_Qty=ifnull(invgprec.Block_Qty,0) - ifnull(blk1.Blocked_Qty,0);
invgprec.Available_Qty=ifnull(invgprec.Available_Qty,0) + ifnull(blk1.Blocked_Qty,0);
}
else if(blk1.Blocked_Qty > invgprec.Block_Qty && i == 1)
{
//info "blocked qty is more than available qty";
balqty = ifnull(blk1.Blocked_Qty,0.0) - ifnull(invgprec.Block_Qty,0.0);
invgprec.Available_Qty=balqty;
invgprec.Block_Qty=ifnull(invgprec.Block_Qty,0) - ifnull(blk1.Blocked_Qty,0);
}
if(balqty > 0 && i > 1)
{
//info "balaance qty is more than zero";
//Balance Qty is less
if(balqty <= invgprec.Block_Qty)
{
// info "balance qty is less than available qty";
invgprec.Available_Qty=ifnull(invgprec.Available_Qty,0.0) + ifnull(balqty,0.0);
invgprec.Block_Qty=ifnull(invgprec.Block_Qty,0) - ifnull(blk1.Blocked_Qty,0);
balqty = 0;
}
//Balance Qty is More
else if(balqty >= invgprec.Block_Qty)
{
//info "balance qty is greater than available qty";
balqty = ifnull(balqty,0.0) - ifnull(invgprec.Block_Qty,0.0);
invgprec.Available_Qty=balqty;
invgprec.Block_Qty=ifnull(invgprec.Block_Qty,0) - ifnull(blk1.Blocked_Qty,0);
}
}
if(balqty == 0)
{
break;
}
i = i + 1;
}
}
}
}
}
//openUrl("#Script:page.refresh","same window");
openUrl("##Report:MRP_Reverse","same window");
if(var == 1 && input.Form_Mode == "Front")
{
openUrl("#Form:Alert_Messages?Status=" + "RMRP" + "&Value=" + input.Revert_No + "&zc_LoadIn=dialog","same window");
}
else if(input.Form_Mode == "Rear")
{
openUrl("#Form:Alert_Messages?Status=" + "REVMRP" + "&Value=" + input.Revert_No + "&zc_LoadIn=dialog","same window");
}
else if(input.Form_Mode == "ReverseWO")
{
openUrl("#Form:Alert_Messages?Status=" + "MRPRev" + "&Value=" + input.Revert_No + "&zc_LoadIn=dialog","same window");
}
if(input.MRP_RECID != null)
{
get_mrp = MRP[ID == input.MRP_RECID];
//info get_mrp + "mrp";
fet_cwpl = MRP_Subform_CWPL[MRP_Biderection_ID == get_mrp.ID];
fet_gp = MRP_Subform_GP[MRP_Biderection_ID == get_mrp.ID];
input.Revert_By = Employee_Details[Employee_Email == zoho.loginuserid].ID;
input.Revert_Date = zoho.currentdate;
input.Work_Order_No = get_mrp.Work_Order_No1;
input.Sales_Order_No = get_mrp.Sales_Order_No;
input.Part_No = get_mrp.Part_No;
input.Part_Name = get_mrp.Part_Name;
input.MRP_Qty = get_mrp.MRP_Qty;
input.Factory_Warehouse = get_mrp.Factory_Warehouse;
input.Created_By = get_mrp.Created_By.ID;
input.Customer_Name = get_mrp.Customer_Name;
input.Specification = get_mrp.Specification;
hide WO_Qty;
}
i = 0;
//info "outside for";
//info fet_cwpl + "subform";
for each mrpcwpl in fet_cwpl
{
//info "1st for";
i = i + 1;
getrow = Revert_Process1.Revert_MRP_Subform_CWPL();
getrow.S_No=i;
getrow.Part_No=mrpcwpl.Part_No;
getrow.Part_Name=mrpcwpl.Part_Name;
getrow.UoM=mrpcwpl.UoM;
getrow.BoM_Qty=mrpcwpl.BoM_Qty_Old;
getrow.Stock_Qty=mrpcwpl.Stock_Qty;
getrow.Req_Qty=mrpcwpl.Req_Qty;
getrow.Plan_Qty=mrpcwpl.Actual_Qty;
getrow.Blocked_Qty=mrpcwpl.Blocked_Qty;
getrow.Block_Qty=mrpcwpl.Block_Qty;
getrow.bom_stk_qty=mrpcwpl.bom_stk_qty;
cwplCol = Collection();
cwplCol.insert(getrow);
input.Revert_MRP_Subform_CWPL.insert(cwplCol);
}
j = 0;
for each gp in fet_gp
{
j = j + 1;
genral = Revert_Process1.Revert_MRP_Subform_GP();
genral.S_No=j;
genral.Part_No=gp.Part_No;
genral.Part_Name=gp.Part_Name;
genral.UoM=gp.UoM;
genral.Purchase_Qty=gp.Purchase_Qty;
genral.Stock_Qty=gp.Stock_Qty;
genral.Indent_Qty=gp.Indent_Qty;
genral.BoM_Qty=gp.BoM_Qty;
genral.Req_Qty=gp.Plan_Qty;
genral.Blocked_Qty=gp.Blocked_Qty;
genral.Block_Qty=gp.Block_Qty;
gencol = Collection();
gencol.insert(genral);
input.Revert_MRP_Subform_GP.insert(gencol);
}
if(input.Work_Order_Subform_ID != null)
{
fet_wosub = Work_Order_Subform[ID == input.Work_Order_Subform_ID];
get_wo = Work_Order[ID == fet_wosub.Work_Order_Exis_ID];
input.Create_Work_Order_ID = get_wo.ID;
input.WO_Qty = fet_wosub.WO_Qty;
input.Revert_By = Employee_Details[Employee_Email == zoho.loginuserid].ID;
input.Revert_Date = zoho.currentdate;
input.Work_Order_No = get_wo.ID;
input.Sales_Order_No = get_wo.Sales_Order_Nos;
input.Part_No = fet_wosub.Part_No;
input.Part_Name = fet_wosub.Part_Description;
input.Customer_Name = get_wo.Customer_Name;
input.Specification = fet_wosub.Specification;
hide MRP_Qty;
hide Factory_Warehouse;
hide Specification;
hide Created_By;
disable WO_Qty;
}
wosno = 0;
for each wosf in fet_wosub
{
wosno = wosno + 1;
inswo = Revert_Process1.Revert_WO_Subform();
inswo.S_No=wosno;
inswo.Part_No=wosf.Part_No;
inswo.Part_Description=wosf.Part_Description;
inswo.UOM=wosf.UOM;
inswo.SO_Quantity=wosf.SO_Quantity;
inswo.Stock_Qty=wosf.Stock_Qty;
inswo.WO_Pipeline=wosf.WO_Pipeline;
inswo.Required_Qty=wosf.Required_Qty;
inswo.WO_Qty=wosf.WO_Qty;
inswo.Block_Qty=wosf.Block_Qty;
inswo.Balance_Qty=wosf.Balance_Qty;
inswo.WO_Qty_with_buffer=wosf.WO_Qty_with_buffer;
inswo.Specification=wosf.Specification;
wocol = Collection();
wocol.insert(inswo);
input.Revert_WO_Subform.insert(wocol);
}
if(row.Part_Description != null)
{
match_data = Materials[ID == row.Part_Description && Status == "Active"];
row.Rate=ifnull(match_data.Purchase_Price,0.0);
row.Part_No=match_data.ID;
row.Mfr_Part_No=ifnull(match_data.ID,"");
row.Specification=match_data.Specification;
row.Brand=match_data.Brand_Name;
row.Ordered_Qty=ifnull(match_data.MOQ,0);
row.UoM=row.Part_Description.Primary_UoM;
//checking with vendor location with Uttar Pradesh
if(input.Vendor_Name.Place_of_Supply.Destination != "Uttar Pradesh")
{
row.Tax=Materials[ID == row.Part_Description].IGST_Details;
}
else
{
row.Tax=Materials[ID == row.Part_Description].GST_Details;
}
row.Available_Qty=ifnull(Inventory[Part_Description == row.Part_Description].sum(Available_Qty),0.0);
row.MOQ_Qty=ifnull(Materials[ID == row.Part_Description].MOQ,0.0);
//load the rate,moq from the vendor pricing master if available
getvendcust = Vendor_Contract[Vendor_Name == input.Vendor_Name && Status == "Active"];
if(getvendcust.count() > 0)
{
ven_pricing = Vendor_Contract_Subform[Vendor_Name == input.Vendor_Name && Part_Description == row.Part_Description && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"];
//info ven_pricing.count();
if(ven_pricing.count(ID) == 1)
{
row.Rate=null;
row.MOQ_Qty=null;
row.Ordered_Qty=null;
row.Rate=ifnull(ven_pricing.Unit_Price,0.0);
row.MOQ_Qty=ifnull(ven_pricing.MOQ,0.0);
row.Ordered_Qty=ifnull(ven_pricing.MOQ,0.0);
if(row.Rate != ven_pricing.Unit_Price)
{
row.Vendor_contract_Price_check=false;
}
else
{
row.Vendor_contract_Price_check=true;
}
}
}
row.Sub_Total=row.Ordered_Qty * row.Rate;
}
else
{
row.Part_No=null;
row.Available_Qty=null;
row.Ordered_Qty=null;
row.Specification=null;
row.MOQ_Qty=null;
}
//For testing Purpose only Part number created for testing should be selected.
if(input.Vendor_Name != null)
{
if(Vendor_Name.Vendor_Name.startsWithIgnoreCase("Test") == True)
{
if(row.Part_Description != null)
{
if(row.Part_Description.Part_Description.startsWithIgnoreCase("Test") == false)
{
alert "Use Test Part No for Testing";
row.Part_No=null;
row.Part_Description=null;
}
}
}
}
if(row.Part_No != null)
{
match_data = Materials[ID == row.Part_No && Status == "Active"];
row.Part_Description=match_data.ID;
row.Specification=match_data.Specification;
row.Ordered_Qty=ifnull(match_data.MOQ,0);
row.UoM=row.Part_Description.Primary_UoM;
row.Mfr_Part_No=match_data.ID;
row.Brand=match_data.Brand_Name;
if(input.Source_of_Supply.Short_Name == "Out of Scope")
{
clear row.Tax;
row.Tax=GST_Details[Tax_Name == "Out of Scope"].ID;
}
else
{
if(input.Source_of_Supply.Short_Name != "UP")
{
fet_igst = GST_Details[Tax_Name.contains("IGST")].ID.getAll();
clear row.Tax;
row.Tax:ui.add(fet_igst);
row.Tax=Materials[ID == row.Part_No].IGST_Details;
}
else
{
fet_igst = GST_Details[Tax_Name.contains("GST") && !Tax_Name.startswith("I")].ID.getAll();
clear row.Tax;
row.Tax:ui.add(fet_igst);
row.Tax=Materials[ID == row.Part_No].GST_Details;
}
}
row.Available_Qty=ifnull(Inventory[Part_No == row.Part_No].sum(Available_Qty),0.0);
//Unit price and MOq should be come from vendor pricing if vendor record is available in vendor pricing form.
ven_pricing = Vendor_Contract_Subform[Vendor_Name == input.Vendor_Name && Part_Description == row.Part_Description && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"];
//info ven_pricing.ID;
//info ven_pricing.count(ID);
if(ven_pricing.count(ID) == 1)
{
row.Ordered_Qty=ifnull(ven_pricing.MOQ,0.0);
row.Rate=ifnull(ven_pricing.Unit_Price,0.0);
row.MOQ_Qty=ifnull(ven_pricing.MOQ,0.0);
}
check_ven_map = 0;
check_ven_lis = List();
if(input.Vendor_Name != null)
{
chkvendavl = Vendor_Contract[Vendor_Name == input.Vendor_Name && Status == "Active"];
if(chkvendavl.count() > 0)
{
for each sub_val in input.Item_Details
{
check_vendor = Vendor_Contract_Subform[Vendor_Name == input.Vendor_Name && Part_Description == sub_val.Part_Description && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"];
if(check_vendor.count() == 0)
{
check_ven_lis.add(sub_val.Part_No.Part_No);
check_ven_map = 1;
}
if(check_vendor.count() > 0)
{
sub_val.Rate=ifnull(check_vendor.Unit_Price,0.0);
sub_val.Vendor_contract_Price_check=true;
sub_val.MOQ_Qty=ifnull(check_vendor.MOQ,0.0);
if(row.Rate != check_vendor.Unit_Price)
{
row.Vendor_contract_Price_check=false;
}
else
{
row.Vendor_contract_Price_check=true;
}
}
// sendmail
// [
// from :"CWPL ERP<erp@carrierwheels.com>"
// to :"parthasarathy.m@synprosoft.com"
// subject :"Vendor Contract - itemdetils partno validation " + row.Vendor_contract_Price_check
// message :"Vendor Contract - itemdetils partno validation " + input.Vendor_Name.Vendor_Name
// ]
}
}
if(check_ven_map == 1)
{
show asso_vendors;
Flag_for_Not_Associated_Vendors = true;
create_tab = "<table border=1 Style ='color:#ff8b3b'><tr><th>S.No</th><th>Part No</th><th>Associated Vendor(s)</th></tr>";
sno = 1;
for each tab in check_ven_lis
{
ven_lis = List();
for each ven in Vendor_Contract_Subform[Vendor_Name == input.Vendor_Name && Part_Description == sub_val.Part_Description && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"]
{
if(ven.Vendor_Name.Status == "Active")
{
ven_lis.add(ven.Vendor_Name.Vendor_Name);
}
}
create_tab = create_tab + "<tr><td>" + sno + "</td><td>" + tab + "</td><td>" + if(ven_lis.size() == 0,"<b>Not Associated</b>",ven_lis) + "</td></tr>";
sno = sno + 1;
}
create_tab = create_tab + "</table>";
str = "Selected Vendor <b>" + input.Vendor_Name.Vendor_Name + "</b> is not mapped against the following Item(s) : <br><br> " + create_tab;
input.asso_vendors = str;
Do_you_want_to_proceed_anyway = "";
}
else
{
hide asso_vendors;
}
}
}
else
{
row.Part_Description=null;
row.Available_Qty=null;
row.MOQ_Qty=null;
row.Ordered_Qty=null;
row.Specification=null;
hide asso_vendors;
}
//for vendor gst treatment type is Registered Business - composition then GST is null - Parthasarathy - 09/06/2023
getvend = Vendor[ID == input.Vendor_Name];
getgsttreat = GST_Treatment[ID == getvend.GST_Treatment];
if(getgsttreat.GST_Treatment == "Registered Business - Composition")
{
row.Tax=null;
row.Tax_Value=null;
}
//if rate is updated in materials the calculate automatically - 19/12/2022
if(row.Ordered_Qty != null && row.Rate != null && row.Tax != null)
{
get_tax_value = GST_Details[ID == row.Tax].Total_Rate;
tax_calc = row.Ordered_Qty * row.Rate * get_tax_value / 100;
row.Sub_Total=row.Ordered_Qty * row.Rate;
row.Tax_Value=tax_calc;
row.Item_Total=row.Sub_Total + tax_calc;
tot = 0.0;
subtot = 0.0;
for each rec in Item_Details
{
tot = tot + ifnull(rec.Item_Total,0.0);
subtot = subtot + ifnull(rec.Sub_Total,0.0);
}
input.Item_Total = tot;
input.Gross_Total = ifnull(subtot,0.0);
//17082022input.Total = tot + ifnull(input.Extra_Charge_s_Total,0.0);
input.Overall_Total = tot + ifnull(input.Extra_Charge_s_Total,0.0);
}
else
{
row.Sub_Total=ifnull(row.Ordered_Qty,0) * ifnull(row.Rate,0) + ifnull(row.Tax_Value,0.0);
row.Item_Total=ifnull(row.Sub_Total,0.0) + ifnull(row.Tax_Value,0.0);
tot1 = 0.0;
subtot1 = 0.0;
for each rec in Item_Details
{
tot1 = tot1 + ifnull(rec.Item_Total,0);
subtot1 = subtot1 + ifnull(rec.Sub_Total,0.0);
}
//17082022input.Total = ifnull(input.Extra_Charge_s_Total,0.0) + tot1;
input.Gross_Total = ifnull(subtot1,0.0);
input.Overall_Total = ifnull(input.Extra_Charge_s_Total,0.0) + tot1;
input.Item_Total = tot1;
}
//For testing Purpose only Part number created for testing should be selected.
if(input.Vendor_Name != null)
{
if(Vendor_Name.Vendor_Name.startsWithIgnoreCase("Test") == True)
{
if(row.Part_No != null)
{
if(row.Part_No.Part_No.startsWithIgnoreCase("Test") == false)
{
alert "Use Test Part No for Testing";
row.Part_No=null;
row.Part_Description=null;
}
}
}
}
aa = 0;
gt = 0;
it = 0;
for each vv in input.Item_Details
{
if(vv == row)
{
continue;
}
else
{
aa = aa + 1;
vv.S_No=aa;
gt = gt + ifnull(vv.Sub_Total,0);
it = it + ifnull(vv.Item_Total,0);
}
}
input.Gross_Total = gt;
input.Overall_Total = it;
for each recval in input.Delivery_Schedule
{
if(recval.Part_No == row.Part_Description)
{
recval.Part_No=null;
recval.Quantity=null;
recval.Delivery_Date=null;
}
}
itemlist = List();
qtyList = List();
dateList = List();
remarksList = List();
fullQtyList = List();
for each rec in input.Delivery_Schedule
{
if(rec.Part_No != null)
{
itemlist.add(rec.Part_No);
qtyList.add(rec.Quantity);
dateList.add(rec.Delivery_Date);
remarksList.add(rec.Remarks);
fullQtyList.add(rec.Full_Quantity);
}
}
input.Delivery_Schedule.clear();
i = 0;
s_no = 0;
for each items in itemlist
{
s_no = s_no + 1;
row1 = Purchase_Order.Delivery_Schedule();
row1.Part_No=items;
row1.S_No=s_no;
row1.Quantity=qtyList.get(i);
row1.Delivery_Date=dateList.get(i);
row1.Remarks=remarksList.get(i);
row1.Full_Quantity=fullQtyList.get(i);
input.Delivery_Schedule.insert(row1);
i = i + 1;
}
///
check_ven_map = 0;
check_ven_lis = List();
for each sub_val in input.Item_Details
{
if(sub_val.Part_No != row.Part_No)
{
check_vendor = Vendor_Contract_Subform[Vendor_Name == input.Vendor_Name && Part_Description == sub_val.Part_Description && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"];
if(check_vendor.count() == 0)
{
check_ven_lis.add(sub_val.Part_No.Part_No);
check_ven_map = 1;
}
}
}
if(check_ven_map == 1)
{
show asso_vendors;
create_tab = "<table border=1 Style ='color:#ff8b3b'><tr><th>S.No</th><th>Part No</th><th>Associated Vendor(s)</th></tr>";
sno = 1;
for each tab in check_ven_lis
{
ven_lis = List();
for each ven in Vendor_Contract_Subform[Part_Description.Part_No == tab && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"]
{
if(ven.Vendor_Name.Status == "Active")
{
ven_lis.add(ven.Vendor_Name.Vendor_Name);
}
}
create_tab = create_tab + "<tr><td>" + sno + "</td><td>" + tab + "</td><td>" + if(ven_lis.size() == 0,"<b>Not Associated</b>",ven_lis) + "</td></tr>";
sno = sno + 1;
}
create_tab = create_tab + "</table>";
str = "Selected Vendor <b>" + input.Vendor_Name.Vendor_Name + "</b> is not mapped against the following Item(s) : <br><br> " + create_tab;
input.asso_vendors = str;
Do_you_want_to_proceed_anyway = "";
Flag_for_Not_Associated_Vendors = true;
}
else
{
hide asso_vendors;
Flag_for_Not_Associated_Vendors = false;
}
if(Item_Details == null)
{
alert "First Add Data in Item Details";
}
i = 0;
for each rec_sn in input.Delivery_Schedule
{
i = i + 1;
row.S_No=i;
}
//----------------------------------test code for same part number with different spec
item_list1 = List();
deliv_list1 = List();
finalist = List();
item_list = List();
spec_list = List();
for each an_item in input.Item_Details
{
if(an_item.Part_No != null)
{
item_list1.add(ifnull(an_item.Part_Description.concat("-"),"").concat(ifnull(an_item.Specification,"")));
spec_list.add(an_item.Specification);
}
else
{
alert "First Add Data in Item Details";
}
}
for each deliv in input.Delivery_Schedule
{
if(deliv.Part_No != null && deliv.Full_Quantity == true)
{
deliv_list1.add(deliv.Part_No.concat("-").concat(ifnull(deliv.Specification,"")));
}
}
item_list1.removeAll(deliv_list1);
for each itemlistrec in item_list1
{
//finalist.add(itemlistrec.getprefix("-"));
item_list.add(itemlistrec.getprefix("-"));
}
//----------------------------------------test code end here-----------------------------------------------------
//For Delivery Schedule
clear row.Part_No;
/*item_list = List();
deliv_list = List();
for each an_item in input.Item_Details
{
item_list.add(an_item.Part_Description);
}
for each deliv in input.Delivery_Schedule
{
if(deliv.Part_No != null && deliv.Full_Quantity == true)
{
deliv_list.add(deliv.Part_No);
}
}
item_list.removeAll(deliv_list);*/
row.Part_No:ui.add(item_list.sort(true));
if(item_list.size() > 0)
{
row.Part_No=item_list.get(0);
//Setting Quantity
for each itemdetrec in input.Item_Details
{
if(itemdetrec.Ordered_Qty < 1)
{
alert "Please enter quantity for all the item(s) in Item Details Subform";
row.Quantity=null;
}
else
{
dsqtytot = 0;
for each delschrec in input.Delivery_Schedule
{
if(itemdetrec.S_No == delschrec.S_No && itemdetrec.Part_No == delschrec.Part_No && itemdetrec.Specification == delschrec.Specification && delschrec.Full_Quantity == false)
{
row.Specification=delschrec.Specification;
}
//calculate the quantity and comapare with item details qty
if(delschrec.Part_No == itemdetrec.Part_No && delschrec.S_No == itemdetrec.S_No)
{
//if(delschrec.Part_No == itemdetrec.Part_No && delschrec.Specification == itemdetrec.Specification)
dsqtytot = dsqtytot + ifnull(delschrec.Quantity,0.0);
}
//qty,spec
if(itemdetrec.Part_No == row.Part_No && itemdetrec.S_No == row.S_No)
{
row.Quantity=if(dsqtytot > 0,itemdetrec.Ordered_Qty - dsqtytot,itemdetrec.Ordered_Qty);
row.Quantity=itemdetrec.Ordered_Qty;
row.Specification=itemdetrec.Specification;
row.Full_Quantity=true;
}
//itemdetails partno qty splitting in delvy sch with different date
if(itemdetrec.Part_No == row.Part_No && itemdetrec.Specification == row.Specification && row.Full_Quantity == false)
{
row.Specification=itemdetrec.Specification;
row.Quantity=if(dsqtytot > 0,itemdetrec.Ordered_Qty - dsqtytot,itemdetrec.Ordered_Qty);
}
}
}
}
}
if(!isNull(input.Incoterms))
{
if(input.Incoterms_same_for_all_items == "Yes")
{
row.Incoterms=input.Incoterms;
}
else
{
row.Incoterms=null;
}
}
if(!isNull(input.Incoterms_Location1))
{
if(input.Incoterms_Location_same_for_all_items == "Yes")
{
row.Incoterms_Location=input.Incoterms_Location1;
}
else
{
row.Incoterms_Location=null;
}
}
if(!isNull(input.Delivery_Date))
{
if(input.Delivery_Date_same_for_all_items == "Yes")
{
row.Delivery_Date=input.Delivery_Date;
}
else
{
row.Delivery_Date=null;
}
}
//old code for ERP Issue no. 13 & 32 is commented. start below
/*i = 0;
for each rec_sn in input.Delivery_Schedule
{
i = i + 1;
row.S_No=i;
}
//10-07-2019/For Delivery Schedule
clear row.Part_No;
item_list = List();
deliv_list = List();
for each an_item in input.Item_Details
{
item_list.add(an_item.Part_Description);
}
for each deliv in input.Delivery_Schedule
{
if(deliv.Part_No != null && deliv.Full_Quantity == true)
{
deliv_list.add(deliv.Part_No);
}
}
item_list.removeAll(deliv_list);
row.Part_No:ui.add(item_list.sort(true));
if(item_list.size() > 0)
{
row.Part_No=item_list.get(0);
//Setting Quantity
for each rec in input.Item_Details
{
if(rec.Ordered_Qty < 1)
{
alert "Please enter quantity for all the item(s) in Item Details Subform";
row.Quantity=null;
}
else
{
tot = 0.0;
for each rec1 in input.Delivery_Schedule
{
if(rec1.Part_No == rec.Part_Description)
{
tot = tot + ifnull(rec1.Quantity,0.0);
}
}
if(rec.Part_Description == row.Part_No)
{
row.Quantity=if(tot > 0,rec.Ordered_Qty - tot,rec.Ordered_Qty);
row.Full_Quantity=true;
}
}
}
}
if(!isNull(input.Incoterms))
{
if(input.Incoterms_same_for_all_items == "Yes")
{
row.Incoterms=input.Incoterms;
}
else
{
row.Incoterms=null;
}
}
if(!isNull(input.Incoterms_Location1))
{
if(input.Incoterms_Location_same_for_all_items == "Yes")
{
row.Incoterms_Location=input.Incoterms_Location1;
}
else
{
row.Incoterms_Location=null;
}
}
if(!isNull(input.Delivery_Date))
{
if(input.Delivery_Date_same_for_all_items == "Yes")
{
row.Delivery_Date=input.Delivery_Date;
}
else
{
row.Delivery_Date=null;
}
}*/
//old code end above
fet_pref = Preferences[Module_Name = "GRN"];
input.Auto_Approval = fet_pref.Auto_Approval;
//_________________________________________________________________
hide Item_Details.Purchase_Order_Number;
hide Item_Details.Tax_Value;
hide Item_Details.Tax;
hide Item_Details.Income_Quality_Check_Process;
hide Item_Details.zinvt_line_item_id;
hide Item_Details.zinvt_item_id;
hide Purchase_Order_Subform_RECID;
hide Transportation_details.GRN_Main_RECID;
input.Received_By = Employee_Details[Employee_Email == zoho.loginuserid].ID;
input.GRN_Time = zoho.currenttime;
disable GRN_Time;
if(Purchase_Order_Subform_RECID != null || Purchase_Order_Subform_RECID.size() > 0)
{
TotalValue = 0;
tot_qty = 0;
i = 0;
input.Goods_Received_Note_Date = zoho.currentdate;
for each PORec in input.Purchase_Order_Subform_RECID
{
i = i + 1;
getPosub = Purchase_Order_Subform[ID == PORec.ID && PO_Status == "GRN Pending" || PO_Status == "Gate Entry Partially Done" || PO_Status == "GRN Partially Received"];
getPOMain = Purchase_Order[ID == getPosub.Purchase_Order_ExisID];
//get the indent raised by and department details - user requirememnt - 12/12/2022
getindentsf = Indent_Sub_Form[ID == getPOMain.Indent_Sub_Form_RECID];
getindent = Indent[ID == getindentsf.Indent_Form_RECID];
// getindentno = Indent_Sub_Form[Purchase_Order_Subform_RECIDD == PORec.ID];
getindentno = Indent_Sub_Form[ID == getPosub.Indent_Sub_Form];
//info getindentno;
getmaterials = Materials[ID == getPosub.Part_No];
getcategory = Category[ID == getmaterials.Category];
//info getcategory;
if(getindent.count() = 0)
{
hide Indent_No;
hide Indentor;
hide Department;
}
else
{
input.Indent_No = getindentno.Indent_No;
disable Indent_No;
input.Indentor = getindent.Request_Raised_By;
disable Indentor;
input.Department = getindent.Department;
disable Department;
}
input.Purchase_Order = getPosub.Purchase_Order_ExisID;
input.Purchase_Order_Nos = (input.Purchase_Order_Subform_RECID.Purchase_Order_ExisID.getall()).distinct();
//input.Mode_of_delivery = getPOMain.Shipping_Mode;//field deleted as per user request - 31/01/2023
input.Purchase_Order_Number = getPOMain.ID;
input.Purchase_Order_Date = getPOMain.Purchase_Order_Date;
disable Purchase_Order;
disable Mode_of_delivery;
disable Purchase_Order_Number;
disable Purchase_Order_Date;
input.Vendor_Name = getPOMain.Vendor_Name;
gatefet = Create_Gate_Entry1[Vendor_Name == input.Vendor_Name && GEP_Status != "Closed"].ID.getAll();
input.Gate_Entry_No:ui.add(gatefet);
disable Vendor_Name;
Get_Tax_Perc = GST_Details[ID == getPosub.Tax].Total_Rate;
if(Get_Tax_Perc != null)
{
Tax_Amount = (ifnull(PORec.Ordered_Qty,0) - ifnull(PORec.Qty_Received_so_far,0)) * ifnull(getPosub.Rate,0.00) * Get_Tax_Perc / 100;
}
if(Get_Tax_Perc != null)
{
Total_Amount = (ifnull(PORec.Ordered_Qty,0) - ifnull(PORec.Qty_Received_so_far,0)) * ifnull(getPosub.Rate,0.00) + ifnull(Tax_Amount,0.0);
}
else
{
Total_Amount = (ifnull(PORec.Ordered_Qty,0) - ifnull(PORec.Qty_Received_so_far,0)) * ifnull(getPosub.Rate,0.00);
}
//Disable all Subform Fields except Received Quantity.
hide Item_Details.GRN_Created_Date;
if(getcategory.Category != "HR Coils")
{
hide Item_Details.HR_Coil_id;
}
else
{
hide Item_Details.HR_Coil_id;
}
disable Item_Details.S_No;
disable Item_Details.GRN_Created_Date;
disable Item_Details.Part_No;
disable Item_Details.Part_Description;
disable Item_Details.Specification;
disable Item_Details.UoM;
disable Item_Details.Ordered_Qty;
disable Item_Details.Received_Qty_So_far;
disable Item_Details.Rate;
disable Item_Details.Sub_Total;
disable Item_Details.Tax;
disable Item_Details.Tax_Value;
disable Item_Details.Amount;
disable Item_Details.Balance_Qty;
//disable Item_Details.MFG_Date; comment on 6.9.2022 by partha
//disable Item_Details.Exp_Date; comment on 6.9.2022 by partha
disable Item_Details.PO_ID;
disable Item_Details.Purchase_Order_SubForm_RECID;
disable Item_Details.Batch_Number;
disable Item_Details.Total_Price;
disable Item_Details.Barcode;
disable Item_Details.GRN_ID;
disable Item_Details.HR_Coil_id;
disable Item_Details.Indentor;
disable Item_Details.Indent_No;
disable Item_Details.Indentor_Dept;
//ItemDetails Subform - Declaring the Row for Subform
ItemDetailSFRow = GRN.Item_Details();
// assigning values for various subform fields in the row
ItemDetailSFRow.S_No=i;
ItemDetailSFRow.GRN_Created_Date=zoho.currentdate;
ItemDetailSFRow.Part_No=getPosub.Part_No;
ItemDetailSFRow.Part_Description=getPosub.Part_Description;
ItemDetailSFRow.Specification=getPosub.Specification;
ItemDetailSFRow.UoM=getPosub.UoM;
ItemDetailSFRow.Rate=ifnull(getPosub.Rate,0.00);
ItemDetailSFRow.Sales_Order_No=getPosub.Sales_Order_No;
ItemDetailSFRow.PO_ID=getPosub.Purchase_Order_ExisID;
ItemDetailSFRow.Purchase_Order_SubForm_RECID=PORec.ID;
ItemDetailSFRow.Ordered_Qty=getPosub.Ordered_Qty;
ItemDetailSFRow.Received_Qty=Ifnull(getPosub.Ordered_Qty,0) - Ifnull(getPosub.Qty_Received_so_far,0);
//Pooja ItemDetailSFRow.Received_Qty=ifnull(getPosub.Qty_Recieved_so_far_GE,0);
//ItemDetailSFRow.Received_Qty=ifnull(getPosub.Qty_Recieved_so_far_GE,0) - ifNull(getPosub.Qty_Received_so_far,0);
ItemDetailSFRow.Balance_Qty=ifnull(getPosub.Ordered_Qty,0) - (ifnull(ItemDetailSFRow.Received_Qty,0) + ifnull(getPosub.Qty_Received_so_far,0));
ItemDetailSFRow.Received_Qty_So_far=Ifnull(getPosub.Qty_Received_so_far,0);
ItemDetailSFRow.Sub_Total=(ifnull(getPosub.Ordered_Qty,0) - ifnull(getPosub.Qty_Received_so_far,0)) * ifnull(getPosub.Rate,0.00);
if(getPosub.Tax != null)
{
ItemDetailSFRow.Tax=Ifnull(getPosub.Tax,"");
ItemDetailSFRow.Tax_Value=ifnull(Tax_Amount,0.00);
}
if(getPosub.Tax == null)
{
ItemDetailSFRow.Amount=ifnull(ItemDetailSFRow.Sub_Total,0.00);
}
else
{
ItemDetailSFRow.Amount=ifnull(ItemDetailSFRow.Sub_Total,0.00) + ifnull(ItemDetailSFRow.Tax_Value,0.00);
}
ItemDetailSFRow.Total_Price=ItemDetailSFRow.Amount;
ItemDetailSFRow.Purchase_Order_Number=getPOMain.ID;
TotalValue = ifnull(TotalValue,0.00) + ifnull(ItemDetailSFRow.Amount,0.00);
tot_qty = tot_qty + ifnull(ItemDetailSFRow.Received_Qty,0);
//ItemDetailSFRow.Indent_No=getindent.Indent_No;
ItemDetailSFRow.Indent_No=ifnull(getindentno,"");
ItemDetailSFRow.Indentor=getindent.Request_Raised_By;
ItemDetailSFRow.Indentor_Dept=getindent.Department;
//ItemDetailSFRow.HR_Coil_id=Coil_id;
// declare a variable to hold the collection of rows
ItemDetailSfCol = Collection();
ItemDetailSfCol.insert(ItemDetailSFRow);
// insert the rows into the subform through the variable
input.Item_Details.insert(ItemDetailSfCol);
}
//Retrieve the Transportation details
/* fetgateentry = Gate_Entry_Process[Purchase_Order_No == input.Purchase_Order_Number];
if(fetgateentry.count() > 0)
{
fettransentry = Gate_Entry_Transport_Details[Gate_Entry_Process_RECID == fetgateentry.ID];
for each transrec in fettransentry
{
//if(fettransentry.count() > 0)
// {
TransportSFRow = GRN.Transportation_details();
TransportSFRow.Vehicle_No=transrec.Vehicle_No;
TransportSFRow.Name_of_Transport=transrec.Name_of_Transport;
TransportSFRow.Driver_Name=transrec.Driver_Name;
TransportSFRow.Driver_Contact_No=transrec.Driver_Contact_No;
TransportSFRow.GR_RR_No=transrec.GR_RR_No;
TransportSFRow.GR_RR_Date=transrec.GR_RR_Date;
TransportSFRow.Picture_of_Item_Lorry=transrec.Picture_of_Item_Lorry;
TransportSFRow.Picture_Description=transrec.Picture_Description;
TransportSfCol = Collection();
TransportSfCol.insert(TransportSFRow);
// insert the rows into the subform through the variable
input.Transportation_details.insert(TransportSfCol);
disable Transportation_details.Vehicle_No;
disable Transportation_details.Name_of_Transport;
disable Transportation_details.Driver_Name;
disable Transportation_details.Driver_Contact_No;
disable Transportation_details.GR_RR_Date;
disable Transportation_details.GR_RR_No;
disable Transportation_details.Picture_Description;
disable Transportation_details.Picture_of_Item_Lorry;
disable Transportation_details.Status;
}
}
else
{
hide Transportation_details;
} */
input.Total_Value = ifnull(TotalValue,0.00);
input.Total_Quantity = ifnull(tot_qty,0.00);
html = "<html><head><style>#customers {font-family: 'Trebuchet MS', Arial, Helvetica, sans-serif;border-collapse: collapse;width: 100%;}#customers td, #customers th {border: 1px solid #ddd;padding: 8px;}#customers tr:nth-child(even){background-color: #f2f2f2;}#customers tr:hover {background-color: #ddd;}#customers th { padding-top: 12px;padding-bottom: 12px;text-align: left;background-color: #f9f9f9;}</style></head><body>";
html = html + "<table id='customers'><th style='text-align:center;'>PO Form</th></tr>";
Val_url = "https://app.zohocreator.in/carrierwheels/erp/#Page:PO_Template?ID=" + input.Purchase_Order + "&zc_LoadIn=dialog&zc_Header=false";
urlvalue = "<a href='" + Val_url + "'>View PO</a>";
html = html + "</td><td>" + urlvalue + "</td></tr>";
html = html + "</table></body></html>";
input.plain = html;
}
disable Material_Landing_Rack;
if(input.Material_Landing_Rack == null)
{
fet_mat = Rack_Master[Racks_Bins == "Store Incoming Area"];
input.Material_Landing_Rack = fet_mat.ID;
}
fetblk = FG_Block_Stock1[ID == input.FG_Block_Stock_ID];
hide FG_Block_Stock_ID;
input.Work_Order_No = fetblk.WO_No;
input.Blocked_Qty = fetblk.Block_Qty;
input.Part_No = fetblk.Part_No;
input.Part_Name = fetblk.Part_Name;
input.Unblocking_Date = zoho.currentdate;
input.Unblocked_By = Employee_Details[Employee_Email == zoho.loginuserid].ID;
input.Unblock_Qty = fetblk.Block_Qty;
disable Part_No;
disable Part_Name;
disable Blocked_Qty;
disable Unblocking_Date;
disable Work_Order_No;
disable Unblocked_By;
disable Balance_Blocked_Qty;
disable Blocked_Qty_So_far;
hide Blocked_Qty_So_far;
disable Balance_Blocked_Qty;
hide Status;
if(fetblk.Status == "Partially UnBlocked")
{
input.Unblock_Qty = fetblk.Balance_Blocked_Qty;
input.Balance_Blocked_Qty = fetblk.Balance_Blocked_Qty;
input.Blocked_Qty_So_far = fetblk.Quantity_Blocked_So_far;
show Blocked_Qty_So_far;
show Balance_Blocked_Qty;
}
fetblk = FG_Block_Stock1[ID == input.FG_Block_Stock_ID];
if(fetblk.Status != "Partially UnBlocked")
{
input.Balance_Blocked_Qty = ifnull(fetblk.Block_Qty,0) - ifnull(input.Unblock_Qty,0);
}
if(fetblk.Status == "Partially UnBlocked")
{
input.Balance_Blocked_Qty = ifnull(fetblk.Quantity_Blocked_So_far,0) - ifnull(input.Unblock_Qty,0);
}
if(input.Balance_Blocked_Qty < 0)
{
input.Balance_Blocked_Qty = 0;
}
if(input.Unblock_Qty <= 0)
{
alert "Unblock qty not should be zero or less than zero";
input.Unblock_Qty = null;
input.Balance_Blocked_Qty = 0;
input.Balance_Blocked_Qty = 0;
}
else if(input.Unblock_Qty > Blocked_Qty)
{
alert "Unblock qty not more than blocked qty";
input.Unblock_Qty = null;
}
if(fetblk.Status == "Partially UnBlocked" && input.Unblock_Qty > fetblk.Balance_Blocked_Qty)
{
alert "Unblock Qty shouldn't be greater than Balance Blocked Qty";
input.Unblock_Qty = fetblk.Balance_Blocked_Qty;
}
fetch_inv = Inventory[Part_No == input.Part_No] sort by Available_Qty desc;
fet_chk = FG_Block_Stock1[ID == input.FG_Block_Stock_ID];
if(input.Unblock_Qty == fet_chk.Block_Qty || input.Unblock_Qty == fet_chk.Balance_Blocked_Qty)
{
fet_chk.Quantity_Blocked_So_far=ifnull(fet_chk.Quantity_Blocked_So_far,0) + input.Unblock_Qty;
fet_chk.Unblocked_Qty=fet_chk.Block_Qty;
fet_chk.Balance_Blocked_Qty=0;
fetch_inv.Block_Qty=ifnull(fetch_inv.Block_Qty,0) - input.Unblock_Qty;
fetch_inv.Available_Qty=ifnull(fetch_inv.Available_Qty,0) + input.Unblock_Qty;
fet_chk.Status="Fully UnBlocked";
input.Status = "Fully UnBlocked";
}
else if(input.Unblock_Qty < fet_chk.Block_Qty && input.Unblock_Qty != fet_chk.Balance_Blocked_Qty)
{
fet_chk.Quantity_Blocked_So_far=ifnull(fet_chk.Quantity_Blocked_So_far,0) + input.Unblock_Qty;
fet_chk.Unblocked_Qty=ifnull(fet_chk.Quantity_Blocked_So_far,0);
if(fet_chk.Balance_Blocked_Qty == null)
{
fet_chk.Balance_Blocked_Qty=fet_chk.Block_Qty - input.Unblock_Qty;
}
else
{
fet_chk.Balance_Blocked_Qty=fet_chk.Balance_Blocked_Qty - input.Unblock_Qty;
}
fetch_inv.Block_Qty=ifnull(fetch_inv.Block_Qty,0) - input.Unblock_Qty;
fetch_inv.Available_Qty=ifnull(fetch_inv.Available_Qty,0) + input.Unblock_Qty;
fet_chk.Status="Partially UnBlocked";
input.Status = "Partially UnBlocked";
}
openUrl("#Form:Alert_Messages?Status=" + "UNBlOCK" + "&Value=" + input.Unblock_Qty + "&zc_LoadIn=dialog","same window");
void Payments.Payments(int booksid)
{
fet_payBook = Get_Payments_ID_from_Books[ID == input.booksid];
bksid = fet_payBook.Payment_Books_ID;
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
get_payresp = zoho.books.getRecordsByID("customerpayments",org_id,bksid,conn_tok);
// info get_payresp;
pay_data = get_payresp.tomap().get("payment");
// info pay_data ;
custname = pay_data.get("customer_name");
payid = pay_data.get("payment_id");
custid = pay_data.get("customer_id");
//info custid;
invoices = pay_data.get("invoices").toList();
invlist = List();
invid = List();
invamt = List();
payamnt = List();
for each rec in invoices
{
map_val = rec.toMap();
invoice_ID = map_val.get("invoice_id");
invoice_no = map_val.get("invoice_number");
inv_amnt = map_val.get("invoice_amount");
pay_amnt = map_val.get("amount_applied");
fetinv = Invoice[Zoho_Books_ID == invoice_ID].ID;
fetinvno = Invoice[Invoice_No == invoice_no];
fetinvamnt = Invoice[Grand_Total == inv_amnt];
fetpayamnt = Payments[Payment_Amount == pay_amnt];
invlist.add(fetinvno);
invid.add(fetinv);
invamt.add(inv_amnt);
pay_amnt.add(pay_amnt);
}
customer_id = Customers[Customer_Books_ID == custid].ID;
amtrec = pay_data.get("amount");
paydate = pay_data.get("date");
//--------------------------------------------------
paymode = pay_data.get("payment_mode");
invdate = pay_data.get("date");
// invno = pay_data.get("invoice_number");
payno = pay_data.get("payment_number");
payins = insert into Payments
[
Added_User=zoho.loginuser
Customer_Name=customer_id
Payment_ID=payid
Customer_ID=custid
Amount_Received=amtrec
Payment_Date=paydate
Payment_Mode=paymode
Invoice_Date=invdate
Inv_ID=invid
Invoice_No1=invlist
Payment_No=payno
Payment_Status="Success"
Invoice_Amount=invamt
Payment_Amount=payamnt
];
}
void Materials.Items_CRM_Sync(int mat_id)
{
mat = Materials[ID == mat_id];
matmap = Map();
matmap.put("Product_Code",mat.Part_No);
matmap.put("Product_Name",mat.Part_Description);
matmap.put("Specification",mat.Specification);
matmap.put("Usage_Unit",mat.Primary_UoM.UOM);
matmap.put("Creator_ID",mat.ID.toString());
matmap.put("Brand_Name",ifNull(mat.Brand_Name.Brand_Name,""));
matmap.put("Alternate_UoM",mat.Alternate_UoM.UOM);
matmap.put("Rounding_Value",mat.Rounding_Value);
matmap.put("Primary_UoM",mat.Primary_UoM.UOM);
matmap.put("MOQ_Minimum_Lot_Size",mat.MOQ);
matmap.put("Procurement_Lead_Time_Days",mat.Procurement_Lead_Time_Days);
matmap.put("Planning_Procedure",mat.Planning_Procedure);
matmap.put("Blank_Length",mat.Blank_Length);
matmap.put("Blank_Width",mat.Blank_Width);
matmap.put("Blank_Thickness",mat.Blank_Thickness);
matmap.put("Blank_Weight",mat.Blank_Weight);
matmap.put("Final_Weight",mat.Final_Weight);
matmap.put("Surface_Area_in_mm2",mat.Surface_Area);
matmap.put("Maximum_Stock",mat.Maximum_Stock);
matmap.put("Minimum_Stock",mat.Minimum_Stock);
matmap.put("GST_Details",mat.GST_Details.Tax_Name);
matmap.put("IGST_Details",mat.IGST_Details.Tax_Name);
matmap.put("HSN_SAC",mat.HSN_SAC);
if(mat.Zoho_Books_ID != Null)
{
matmap.put("Books_ID",mat.Zoho_Books_ID.toString());
}
dummymap = Map();
if(isNull(mat.CRM_ID))
{
crmsync = zoho.crm.createRecord("Products",matmap,dummymap,"crm_connection");
mat.CRM_ID=crmsync.get("id");
info crmsync;
}
else
{
updsync = zoho.crm.updateRecord("Products",mat.CRM_ID.toLong(),matmap,dummymap,"crm_connection");
//info updsync;
}
}
void Invoice.Invoice_Eway_bill_Details_Update()
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
invoicedata = Invoice[Zoho_Books_ID != null && E_Way_Bill_No == ""] sort by Added_Time desc range from 1 to 20;
// invoicedata = Invoice[Zoho_Books_ID != null && E_Way_Bill_No == "" && Sale_Order_No == null] sort by ID desc range from 21 to 30;
//invoicedata = Invoice[Zoho_Books_ID != null && E_Way_Bill_No == "" && Sale_Order_No != null];
//invoicedata = Invoice[Zoho_Books_ID == "917835000036874439" && E_Way_Bill_No == ""];
info invoicedata.count();
i = 0;
for each recxx in invoicedata
{
zbid = recxx.Zoho_Books_ID;
invoice_resp = zoho.books.getRecordsByID("invoices",org_id,zbid.tostring(),conn_tok);
//info "invoice resp code " + invoice_resp.get("code") + "---" + zbid;
ewaybill = invoice_resp.get("invoice").toMap().get("eway_bill_details");
info ewaybill;
if(!isempty(ewaybill))
{
bno = ewaybill.get("eway_bill_number");
if(!isnull(bno))
{
recxx.E_Way_Bill_No=ewaybill.get("eway_bill_number");
}
if(!isnull(ewaybill.get("eway_bill_date")))
{
recxx.E_Way_Bill_Date=ewaybill.get("eway_bill_date").toString("dd-MMM-yyyy");
}
i = i + 1;
}
else if(!isnull(ewaybill))
{
bno = ewaybill.get("eway_bill_number");
if(!isnull(bno))
{
recxx.E_Way_Bill_No=ewaybill.get("eway_bill_number");
}
if(!isnull(ewaybill.get("eway_bill_date")))
{
recxx.E_Way_Bill_Date=ewaybill.get("eway_bill_date").toString("dd-MMM-yyyy");
}
i = i + 1;
}
}
info i;
}
void Indent.Indent_Email_Notification(int myindent_ID)
{
myindent = Indent[ID == myindent_ID];
myindent_itemdetails = Indent_Sub_Form[Indent_Form_RECID == myindent_ID];
getindentor = Employee_Details[ID == myindent.Request_Raised_By];
emailto = getindentor.Employee_Email;
getemail = Email_Template[Template_No == 4];
sub = getemail.Subject_field;
body = getemail.Body;
sub = sub.replaceAll("{prno}",myindent.Indent_No,true);
sub = sub.replaceAll("{prstatus}",myindent.Approval_Status,true);
body = body.replaceAll("{prno}",myindent.Indent_No,true);
body = body.replaceAll("{prdate}",myindent.Indent_Request_Date.tostring("d-MMM-yyyy"),true);
body = body.replaceAll("{prstatus}",myindent.Approval_Status,true);
body = body.replaceAll("{indentor}",getindentor.Employee_Name,true);
if(myindent.Project_Name != null)
{
project = "The indent was placed for the project " + myindent.Project_Name.Project_Number + " - " + myindent.Project_Name.Project_Title;
}
else
{
project = null;
}
body = body.replaceAll("{project}",ifnull(project,""),true);
IndentLink = "<a href='https://creatorapp.zoho.in/carrierwheels/erp#Report:All_Indents?Indent_No=" + myindent.Indent_No + "' title='Click to Open Indent' target='_blank'>Click to Open Indent " + myindent.Indent_No + "</a>";
body = body.replaceAll("{link}",IndentLink,true);
tab = "<html><style>th,td {padding: 5px;}</style><table border = 1> <th>S. No.</th> <th>Part No.</th> <th>Part Description</th> <th>Specification</th> <th>Required Qty</th><th>UOM</th> <th>Remarks</th> <th>Purpose of Indent</th>";
count = 1;
for each tablerec in myindent_itemdetails
{
getuom = Unit_of_Measurement[ID == tablerec.UoM].UOM;
tab = tab + "<tr><td>" + count + "</td>";
tab = tab + "<td>" + tablerec.Part_No.Part_No + "</td>";
tab = tab + "<td>" + tablerec.Part_Description.Part_Description + "</td>";
tab = tab + "<td>" + ifnull(tablerec.Specification,"") + "</td>";
tab = tab + "<td>" + ifnull(tablerec.Required_Qty,0) + "</td>";
tab = tab + "<td>" + getuom + "</td>";
tab = tab + "<td>" + ifNull(tablerec.Remarks,"") + "</td>";
tab = tab + "<td>" + ifnull(tablerec.Purpose_of_Indent,"") + "</td></tr>";
count = count + 1;
}
tab = tab + "</table></html>";
body = body.replaceAll("{table}",tab,true);
//info body;
sendmail
[
from :"CWPL ERP <erp@carrierwheels.com>"
to :emailto
reply to :"sourcing@carrierwheels.com"
subject :sub
message :body
]
}
void GRN.Create_GRN(Purchase_Order_Subform posub)
{
poid = list();
povendlist = list();
for each recval in posub
{
poid.add(recval);
fetpomain = Purchase_Order[ID == recval.Purchase_Order_ExisID];
povendlist.add(fetpomain.Vendor_Name);
}
if(povendlist.distinct().size() == 1)
{
openUrl("#Form:GRN?Purchase_Order_Subform_RECID=" + poid,"same window");
}
else
{
openUrl("#Form:Alert_Messages?Status=GRN&Value=Selected Vendors are not same pls check.&zc_LoadIn=dialog","same window");
}
}
void GRN.GRN_Email_Notification(int ID)
{
getgrnsubform = GRN_Subform[GRN_ID == input.ID];
//info getgrnsubform;
getgrnmain = GRN[ID == getgrnsubform.GRN_ID];
//info getgrnmain;
getposubform = Purchase_Order_Subform[ID == getgrnsubform.Purchase_Order_SubForm_RECID];
//info getposubform;
getpomain = Purchase_Order[ID == getposubform.Purchase_Order_ExisID];
//info getpomain;
// getindentsf = Indent_Sub_Form[ID == getposubform.Indent_Sub_Form];
getindentsf = Indent_Sub_Form[Purchase_Order_Subform_RECID == getgrnsubform.Purchase_Order_SubForm_RECID];
//info getindentsf;
getindent = Indent[ID == getindentsf.Indent_Form_RECID];
//info "Get Indent:" + getindent;
getindentor = Employee_Details[ID == getindent.Request_Raised_By];
emailto = getindentor.Employee_Email;
//info "Email To:" + emailto;
getemail = Email_Template[Template_No == 3];
sub = getemail.Subject_field;
body = getemail.Body;
sub = sub.replaceAll("{grnno}",getgrnmain.Goods_Received_Note_Number,true);
sub = sub.replaceAll("{pono}",getpomain.Purchase_Order_No,true);
body = body.replaceAll("{indentor}",ifnull(getindentor.Employee_Name,""),true);
body = body.replaceAll("{grnno}",getgrnmain.Goods_Received_Note_Number,true);
tab = "<html><style>th,td {padding: 5px;}</style><table border = 1> <th>Indent No.</th> <th>Part No.</th> <th>Part Description</th> <th>Specification</th> <th>Quantity Received</th><th>UOM</th> <th>Remarks of Indent</th> <th>Purpose of Indent</th> <th>Zoho Project</th>";
for each tablerec in getgrnsubform
{
getindentno = Indent_Sub_Form[Purchase_Order_Subform_RECID == tablerec.Purchase_Order_SubForm_RECID];
getuom = Unit_of_Measurement[ID == tablerec.UoM].UOM;
if(getindentno.count() > 0)
{
IndentLink = "<a href='https://creatorapp.zoho.in/carrierwheels/erp#Report:All_Indents?Indent_No=" + ifnull(getindentno.Indent_No,"") + "' title='Click to Open Indent' target='_blank'>" + ifnull(getindentno.Indent_No,"") + "</a>";
tab = tab + "<tr><td>" + ifnull(IndentLink,"") + "</td>";
tab = tab + "<td>" + tablerec.Part_No.Part_No + "</td>";
tab = tab + "<td>" + tablerec.Part_Description.Part_Description + "</td>";
tab = tab + "<td>" + ifnull(tablerec.Specification,"") + "</td>";
tab = tab + "<td>" + ifnull(tablerec.Received_Qty,0) + "</td>";
tab = tab + "<td>" + getuom + "</td>";
myindentsf = Indent_Sub_Form[Purchase_Order_Subform_RECID == tablerec.Purchase_Order_SubForm_RECID];
tab = tab + "<td>" + ifNull(myindentsf.Remarks,"") + "</td>";
tab = tab + "<td>" + ifNull(myindentsf.Purpose_of_Indent,"") + "</td>";
tab = tab + "<td>" + ifnull(myindentsf.Project_Name,"") + "</td></tr>";
}
else
{
//info "else";
IndentLink = "<a href='https://creatorapp.zoho.in/carrierwheels/erp#Report:All_Indents?Indent_No=" + ifnull(getindentno.Indent_No,"") + "' title='Click to Open Indent' target='_blank'>" + ifnull(getindentno.Indent_No,"") + "</a>";
//info "Link:" + IndentLink;
tab = tab + "<tr><td>" + IndentLink + "</td>";
tab = tab + "<td>" + tablerec.Part_No.Part_No + "</td>";
tab = tab + "<td>" + tablerec.Part_Description.Part_Description + "</td>";
tab = tab + "<td>" + ifnull(tablerec.Specification,"") + "</td>";
tab = tab + "<td>" + ifnull(tablerec.Received_Qty,0) + "</td>";
tab = tab + "<td>" + getuom + "</td>";
myindentsf = Indent_Sub_Form[Purchase_Order_Subform_RECID == tablerec.Purchase_Order_SubForm_RECID];
tab = tab + "<td>" + ifNull(myindentsf.Remarks,"") + "</td>";
tab = tab + "<td>" + ifNull(myindentsf.Purpose_of_Indent,"") + "</td>";
tab = tab + "<td>" + ifnull(myindentsf.Project_Name,"") + "</td></tr>";
}
}
//info "Tab:" + tab;
tab = tab + "</table></html>";
body = body.replaceAll("{table}",tab,true);
//info "Body:" + body;
//emp = Employee_Details[Department_Name.Department_Name == "Stores"];
if(getindentno.count() > 0)
{
sendmail
[
from :"CWPL ERP<erp@carrierwheels.com>"
to :emailto
cc:"sourcing@carrierwheels.com"
reply to :"stores@carrierwheels.com"
subject :sub
message :body
]
}
else
{
sendmail
[
from :"CWPL ERP<erp@carrierwheels.com>"
to :"sourcing@carrierwheels.com"
cc:"sourcing@carrierwheels.com"
subject :sub
message :body
]
}
//cc:"sourcing@carrierwheels.com"
}
string financial_year()
{
fin_str = "";
curr_year = zoho.currentdate.getYear();
curr_month = zoho.currentdate.getMonth();
if(curr_month > 3)
{
next_year = curr_year.toLong() + 1;
//last_2_dig = next_year.subString(2,4);
fin_str = curr_year + "-" + next_year;
//Use "last_2_dig" if u want to display last 2 digit of year
}
else
{
next_year = curr_year.toLong() - 1;
//last_2_dig = curr_year.subString(2,4);
fin_str = (curr_year - 1) + "-" + curr_year;
//Use "last_2_dig" if u want to display last 2 digit of year
}
return fin_str;
}
void CRM.Employee_insert_in_CRM(int empid)
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
fetch_emp_id = Employee_Details[ID == input.empid];
mymap = Map();
mymap.put("Name",fetch_emp_id.Employee_Name);
mymap.put("Employee_code",fetch_emp_id.Employee_ID);
mymap.put("Email",fetch_emp_id.Employee_Email);
mymap.put("Phone",fetch_emp_id.Mobile_Number);
mymap.put("Designation",fetch_emp_id.Designation);
mymap.put("Status",fetch_emp_id.Status);
// info mymap;
dummymap = Map();
// info fetch_emp_id.Zoho_CRM_ID;
if(fetch_emp_id.Zoho_CRM_ID == null || fetch_emp_id.Zoho_CRM_ID == "")
{
createincrm = zoho.crm.createRecord("CWPL_Emp",mymap,dummymap,"crm_connection");
emp_id = createincrm.get("id");
//info createincrm;
}
else
{
updatrecincrm = zoho.crm.updateRecord("CWPL_Emp",fetch_emp_id.Zoho_CRM_ID.toLong(),mymap);
emp_id = updatrecincrm.get("id");
//info updatrecincrm;
}
// info createincrm;
info emp_id;
//Error in log file--Mismatch of data type expression. Expected BIGINT but found STRING Line:(26)
if(fetch_emp_id.Zoho_CRM_ID == null || fetch_emp_id.Zoho_CRM_ID == "")
{
fetch_emp_id.Zoho_CRM_ID=emp_id;
}
}
string Common.Number_Function_New(String module_name)
{
//---------Sales Order - Contract prefix should be "CO" - Direct & Tooling is "SO" - user requirement dt 25/04/2023
if(module_name == "Sales Order Direct")
{
fetch_sale_rec = Sales_Order[Sale_Order_No != null && Sale_Order_No != "" && Sales_Type != "Contract"] sort by Sale_Order_No desc;
//fetch_sale_rec = Sales_Order[Sale_Order_No != null && Sale_Order_No != ""] sort by Sale_Order_No desc;
fet_mod = Module_Master[Module_Name == module_name];
fetch_module = Auto_Generate_Numbers[Module_Name.Module_Name == fet_mod.Module_Name];
mod_short = fetch_module.Module_Short_Name;
if(fetch_module.Choose_Prefix == "New Prefix")
{
num_prefix = fetch_module.Prefix;
}
else if(fetch_module.Choose_Prefix == "Company Short Name")
{
num_prefix = fetch_module.Company_Short_Name;
}
if(fetch_sale_rec.count() == 0)
{
so_value = fetch_module.Number_Should_Start_at;
}
else
{
last_so = getsuffix(getSuffix(fetch_sale_rec.Sale_Order_No,"-"),"-");
so_value = (last_so.toLong() + 1).trim().leftpad(6).replaceAll(" ","0");
}
Order_no = mod_short + "-" + num_prefix + "-" + so_value;
}
//Sales Order Contract 27/04/2023
else if(module_name == "Sales Order Contract")
{
fetch_sale_co = Sales_Order[Sale_Order_No != null && Sale_Order_No != "" && Sales_Type == "Contract"] sort by Added_Time desc;
fet_mod = Module_Master[Module_Name == module_name];
fetch_module = Auto_Generate_Numbers[Module_Name.Module_Name == fet_mod.Module_Name];
mod_short = fetch_module.Module_Short_Name;
if(fetch_module.Choose_Prefix == "New Prefix")
{
num_prefix = fetch_module.Prefix;
}
else if(fetch_module.Choose_Prefix == "Company Short Name")
{
num_prefix = fetch_module.Company_Short_Name;
}
if(fetch_sale_co.count() == 0)
{
co_value = fetch_module.Number_Should_Start_at;
}
else
{
last_co = getsuffix(getSuffix(fetch_sale_co.Sale_Order_No,"-"),"-");
co_value = (last_co.toLong() + 1).trim().leftpad(6).replaceAll(" ","0");
}
Order_no = mod_short + "-" + num_prefix + "-" + co_value;
}
// for Dispatch Note Format
else if(module_name == "Purchase Order")
{
get_prev_num = Purchase_Order[ID != null && Purchase_Order_No != ""] sort by Purchase_Order_No desc;
fet_mod = Module_Master[Module_Name == module_name];
fetch_module = Auto_Generate_Numbers[Module_Name.Module_Name == fet_mod.Module_Name];
mod_short = fetch_module.Module_Short_Name;
if(fetch_module.Choose_Prefix == "New Prefix")
{
num_prefix = fetch_module.Prefix;
}
else if(fetch_module.Choose_Prefix == "Company Short Name")
{
num_prefix = fetch_module.Company_Short_Name;
}
if(get_prev_num.count() == 0)
{
po_value = fetch_module.Number_Should_Start_at;
}
else
{
last_po = getsuffix(getSuffix(get_prev_num.Purchase_Order_No,"-"),"-");
po_value = (last_po.toLong() + 1).trim().leftpad(6).replaceAll(" ","0");
}
Order_no = mod_short + "-" + num_prefix + "-" + po_value;
}
// for work order
else if(module_name == "Work Order")
{
fetch_work_rec = Work_Order[ID != null && Work_Order_No != ""] sort by Work_Order_No desc;
fet_mod = Module_Master[Module_Name == module_name];
fetch_module = Auto_Generate_Numbers[Module_Name.Module_Name == fet_mod.Module_Name];
mod_short = fetch_module.Module_Short_Name;
if(fetch_module.Choose_Prefix == "New Prefix")
{
num_prefix = fetch_module.Prefix;
}
else if(fetch_module.Choose_Prefix == "Company Short Name")
{
num_prefix = fetch_module.Company_Short_Name;
}
if(fetch_work_rec.count() == 0)
{
wo_value = fetch_module.Number_Should_Start_at;
}
else
{
last_wo = getsuffix(getSuffix(fetch_work_rec.Work_Order_No,"-"),"-");
wo_value = (last_wo.toLong() + 1).trim().leftpad(6).replaceAll(" ","0");
}
Order_no = mod_short + "-" + num_prefix + "-" + wo_value;
}
// for calibration Gauge No
else if(module_name == "Gauge No")
{
fetch_gaug = Calibration_Master[ID != null && Gauge_No != ""] sort by Gauge_No desc;
fet_mod = Module_Master[Module_Name == module_name];
fetch_module = Auto_Generate_Numbers[Module_Name.Module_Name == fet_mod.Module_Name];
mod_short = fetch_module.Module_Short_Name;
if(fetch_module.Choose_Prefix == "New Prefix")
{
num_prefix = fetch_module.Prefix;
}
else if(fetch_module.Choose_Prefix == "Company Short Name")
{
num_prefix = fetch_module.Company_Short_Name;
}
if(fetch_gaug.count() == 0)
{
gaug_value = fetch_module.Number_Should_Start_at;
}
else
{
last_gaug = getsuffix(getSuffix(fetch_gaug.Gauge_No,"/"),"/");
gaug_value = (last_gaug.toLong() + 1).trim().leftpad(6).replaceAll(" ","0");
}
Order_no = mod_short + "/" + num_prefix + "/" + gaug_value;
}
else if(module_name == "Cal Master No")
{
fetch_mast = Calibration_Master[ID != null && Cal_Master_No != ""] sort by Cal_Master_No desc;
fet_mod = Module_Master[Module_Name == module_name];
fetch_module = Auto_Generate_Numbers[Module_Name.Module_Name == fet_mod.Module_Name];
mod_short = fetch_module.Module_Short_Name;
if(fetch_module.Choose_Prefix == "New Prefix")
{
num_prefix = fetch_module.Prefix;
}
else if(fetch_module.Choose_Prefix == "Company Short Name")
{
num_prefix = fetch_module.Company_Short_Name;
}
if(fetch_mast.count() == 0)
{
mast_value = fetch_module.Number_Should_Start_at;
}
else
{
last_mast = getsuffix(getSuffix(fetch_mast.Cal_Master_No,"/"),"/");
mast_value = (last_mast.toLong() + 1).trim().leftpad(6).replaceAll(" ","0");
}
Order_no = mod_short + "/" + num_prefix + "/" + mast_value;
}
return Order_no;
}
void Calibration.CalibrationSticker(Calibration_History calid)
{
cid = List();
itmlis = List();
for each rec in calid
{
cid.add(rec);
calbid = Calibration_History[ID == rec.ID];
itmlis.add(calbid.Item_Name);
}
openUrl("#Page:Test_Cal?var_text=" + cid,"new window");
}
class Solution {
public int maxSubArray(int[] nums) {
int sum=0;
int max=0;
for(int i=0;i<nums.length;i++){
sum+=nums[i];
if(sum<0){
sum=0;
}
else{
if(sum>max){
max=sum;
}
}
}
if(max==0)
max=Integer.MIN_VALUE;
for(int i=0;i<nums.length;i++){
if(nums[i]>max)
max=nums[i];
}
return max;
}
}
void Books.Edit_discpatch_note_actual_invoice(int dnaid)
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
disnote_act = Create_Dispatch_Note_Format[ID == input.dnaid];
fetch_cust = Customers[ID == disnote_act.Customer_Name];
fet_so = Sales_Order[ID == disnote_act.Sales_Order_No];
mymap = Map();
info mymap;
//mymap.put("customer_id",fetch_cust.Customer_Books_ID);
item_list = List();
for each rec in disnote_act.Product_Details
{
if(rec.Individual == false && rec.Actual_Qty > 0)
{
fetchitem = Materials[ID == rec.Product_Code];
line_item_map = Map();
//line_item_map.put("description",fetchitem.Classification);
// info "Product des" + rec.Product_Description;
line_item_map.put("item_id",fetchitem.Zoho_Books_ID);
line_item_map.put("quantity",rec.Actual_Qty);
item_list.add(line_item_map);
}
}
mymap.put("line_items",item_list);
update_inv = zoho.books.updateRecord("invoices","60015333461",disnote_act.Draft_Invoice_ID,mymap,conn_tok);
info update_inv;
for each indrec in disnote_act.Product_Details
{
if(indrec.Individual == true)
{
item_list = List();
inmymap = Map();
fetchitem = Materials[ID == indrec.Product_Code];
line_item_map = Map();
//line_item_map.put("description",fetchitem.Classification);
// info "Product des" + rec.Product_Description;
line_item_map.put("item_id",fetchitem.Zoho_Books_ID);
line_item_map.put("quantity",indrec.Actual_Qty);
item_list.add(line_item_map);
inmymap.put("line_items",item_list);
update_inv_ind = zoho.books.updateRecord("invoices","60015333461",indrec.Zoho_Books_Invoice_ID,inmymap,conn_tok);
info update_inv_ind;
}
}
}
void Books.Cancel_SO_in_ZBooks(int soid)
{
//Getting authtoken and organisation id
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
//------------------------------------------------------------------------------
fetch_so = Sales_Order[ID == input.soid];
info fetch_so.Sale_Order_No;
mymap = Map();
stts = "void";
mymap.put("status",stts);
//item_list = List();
/* for each rec in fetch_so.Item_Details
{
fetchitem = Materials[ID == rec.Part_Description];
line_item_map = Map();
line_item_map.put("quantity",rec.Qty);
//line_item_map.put("rate",rec.Rate);
lineitemid = rec.zb_line_item_id;
line_item_map.put("line_item_id",lineitemid);
item_list.add(line_item_map);
}*/
//mymap.put("line_items",item_list);
//status to changed
refno = fetch_so.Sale_Order_No;
books_id = fetch_so.Zoho_Books_ID;
//updtstatus = zoho.books.updateRecord("salesorders",org_id,books_id,mymap,conn_tok);
test_map = Map();
header_data = Map();
header_data.put("content-type","application/json");
void_so = invokeurl
[
url :"https://www.zohoapis.in/books/v3/salesorders/" + books_id + "/status/void?organization_id=" + org_id
type :POST
parameters:test_map
headers:header_data
connection:"books_con"
];
res_code = void_so.get("code").toLong();
log_type = "Failure";
if(res_code == 0)
{
log_type = "Success";
}
ins_log = insert into Log_Files
[
Added_User=zoho.loginuser
Module_Name="Sales Order"
Form_Name="Cancel Sales Order"
Log_Details=void_so
Log_Type=log_type
Reference_NO=refno
];
}
void Books.Create_Shipment(int shipid)
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
fetchdisp = Create_Dispatch_Note_Format[ID == input.shipid];
fetdispsf = Dispatch_Note_Subform[Create_Dispatch_Note_Plan_RECID == fetchdisp.ID];
fetinv = Invoice[ID == fetchdisp.Create_Dispatch_Note_Plan_ID];
fetch_cust = Customers[ID == fetchdisp.Customer_Name];
fetchso = Sales_Order[ID == fetchdisp.Sales_Order_ID];
soid = fetchso.Zoho_Books_ID;
pkgid = fetchdisp.Package_ID;
ss = soid.tostring();
//info soid;
//info pkgid;
grnmap = Map();
//mymap.put("delivered_date",fetchdisp.Actual_Date_Time);
mymap = Map();
mymap.put("date",fetchdisp.Dispatch_Note_Date.toString("yyyy-MM-dd"));
mymap.put("delivery_method","By Road");
mymap.put("tracking_number",fetchdisp.Vehicle_No_dup);
//mymap.put("delivered_date",fetchdisp.Actual_Date_Time);
grnmap.put("JSONString",mymap);
// info grnmap;
// json = Map();
// json.put("JSONString",grnmap);
crtrecord = invokeurl
[
url :"https://www.zohoapis.in/inventory/v3/shipmentorders?package_ids=" + pkgid + "&salesorder_id=" + ss + "&organization_id=" + org_id + "&is_delivered=" + true
type :POST
parameters:mymap.tostring()
connection:"zoho_inventory"
];
//crtrecord = zoho.books.createRecord("shipmentorders", org_id, grnmap);
// info crtrecord;
rescode = crtrecord.get("code").toLong();
log_type = "Failure";
if(rescode == 0)
{
log_type = "Success";
/* var = crtrecord.get("shipment_order").get("shipment_id");
fetchdisp.Shipment_ID=var; */
//info rescode;
}
/* ins_log = insert into Log_Files
[
Added_User=zoho.loginuser
Module_Name="shipments-Books"
Form_Name="Dispatch_Note_Actual_In_Books-shipments"
Log_Details=crtrecord
Log_Type=log_type
Reference_NO=fetchdisp.CDNF_ID
]; */
}
void Books.SyncVirtualStock(int recid)
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
getinventory = Inventory[ID != null];
//cnt = 0;
for each rec in getinventory
{
fet_vs = Virtual_Stock[Inventory_Rec_ID == rec.ID];
//info fet_vs.Part_No.Part_No;
if(fet_vs.count() == 0)
{
// cnt = cnt + 1;
// info rec.Part_No.Part_No;
ins = insert into Virtual_Stock
[
Warehouse=rec.Warehouse
Available_Qty=rec.Available_Qty
Part_Description=rec.Part_Description
Sub_Location=rec.Sub_Location
Location_Name=rec.Location_Name
Rack_Number=rec.Rack_Number
Total_Qty=rec.Total_Qty
Part_No=rec.Part_No
UOM=rec.UOM
Category=rec.Category
Sub_Category=rec.Sub_Category
Inventory_Rec_ID=rec.ID
Added_User=zoho.loginuser
];
}
else if(fet_vs.Block_Qty == null || fet_vs.Block_Qty >= 0)
{
fet_vs.Available_Qty=rec.Available_Qty;
fet_vs.Total_Qty=rec.Total_Qty;
fet_vs.Block_Qty=rec.Block_Qty;
}
}
//info cnt;
}
void Books.invoice_delete_in_books(int Draft_Invoice_ID)
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
//new api ur
del_book = invokeurl
[
url :"https://www.zohoapis.in/books/v3/invoices/" + input.Draft_Invoice_ID + "?organization_id=60015333461"
type :DELETE
connection:"zoho_inventory"
];
// del_book = invokeurl
// [
// url :"https://www.zohoapis.in/books/v3/invoices/" + input.Draft_Invoice_ID + "?organization_id=60015333461"
// type :DELETE
// connection:"zoho_inventory"
// ];
info del_book;
}
map Books.Purchase_Order(int var)
{
//Getting authtoken and organisation id
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
//-------------------------------------------------------------------------
fetchpo = Purchase_Order[ID == input.var];
fetchposf = Purchase_Order_Subform[Purchase_Order_ExisID == fetchpo];
fetchven = Vendor[ID == fetchpo.Vendor_Name];
//fetchshipp = Shipping_Mode[ID == fetchpo.Shipping_Mode];
fetchwarehouse = Warehouse[ID == fetchpo.Deliver_To].Warehouse_Books_ID;
//info fetchwarehouse;
fettax = GST_Details[ID == fetchpo.Item_Details.Tax];
fetch_del_schd = Delivery_Schedule[Purchase_Order_Exis_ID == input.var].maximum(Delivery_Date);
fetch_payment_trms = Payment_Terms[ID == fetchpo.Payment_Terms];
delivery_date = fetch_del_schd.toString("yyyy-MM-dd");
//info "fetchpo.Zoho_Books_ID" + fetchpo.Zoho_Books_ID;
if(fetchpo.Zoho_Books_ID == "" || fetchpo.Zoho_Books_ID == null)
{
//info "Insidee";
pomap = Map();
pomap.put("customer",fetchven.Vendor_Name);
pomap.put("purchaseorder_number",fetchpo.Purchase_Order_No);
pomap.put("vendor_id",fetchven.ZOHO_Books_ID);
pomap.put("purchaseorder_number",fetchpo.Purchase_Order_No);
po2 = fetchpo.Purchase_Order_Date.toString("yyyy-MM-dd");
pomap.put("phone",fetchven.Mobile);
pomap.put("email",fetchven.Email_ID);
pomap.put("date",po2);
pomap.put("cf_payment_terms",fetch_payment_trms.Stages);
//info url_to_po;
pomap.put("delivery_date",delivery_date);
pomap.put("delivery_address",fetchpo.Shipping_Address);
url_to_po = "https://creatorapp.zoho.in/carrierwheels/erp/#Page:PO_Template?ID=" + var;
//new_url_to_po = "<a href='https://creatorapp.zoho.in/carrierwheels/erp/#Page:PO_Template?ID=" + var + "' target='_blank' title='Open PO'>Download PO from ERP</a>";
custom_list = List();
custom_map = Map();
custom_map.put("api_name","cf_download_po_from_erp");
custom_map.put("value",url_to_po);
custom_list.add(custom_map);
pomap.put("custom_fields",custom_list);
//pomap.put("status", "Open");
item_list = List();
//info pomap;
tx_val = 0;
for each rec in fetchpo.Item_Details
{
fetchitem = Materials[ID == rec.Part_Description];
//info fetchitem;
line_item_map = Map();
//custom_list1 = List();
//custom_map1 = Map();
line_item_map.put("name",rec.Part_Description.Part_Description);
line_item_map.put("item_id",fetchitem.Zoho_Books_ID);
mfrPartNo = "";
if(fetchitem.Mfr_Part_No != "")
{
mfrPartNo = "Manufacturer Part No: " + fetchitem.Mfr_Part_No;
}
myspecs = "";
if(rec.Specification != null)
{
myspecs = "Specifications: " + rec.Specification + "\n";
}
myremarks = "";
if(rec.Remarks != null)
{
myremarks = "Remarks: " + rec.Remarks + "\n";
}
line_item_map.put("description",myspecs + myremarks + mfrPartNo);
//line_item_map.put("description",rec.Part_Description.Specification);
line_item_map.put("quantity",rec.Ordered_Qty);
line_item_map.put("rate",rec.Rate);
line_item_map.put("warehouse_name",fetchwarehouse);
line_item_map.put("tax_id",fettax.Zoho_Books_ID);
line_item_map.put("tax_percentage",fettax.Total_Rate);
// custom_map1.put("api_name","cf_posubformid");
// custom_map1.put("value",rec.ID);
// custom_list1.add(custom_map1);
// line_item_map.put("custom_fields",custom_list1);
item_list.add(line_item_map);
tx_val = tx_val + ifnull(rec.Tax_Value,0.00);
}
//info item_list;
for each extra in Additional_Charges_Subform[Purchase_Order_Exis_ID == input.var]
{
line_item_map = Map();
line_item_map.put("name",extra.Charge_Name.Zoho_Books_ID);
line_item_map.put("rate",extra.Rate);
line_item_map.put("quantity",1);
line_item_map.put("item_total",extra.Total);
line_item_map.put("tax_id",extra.Tax.Zoho_Books_ID);
line_item_map.put("tax_percentage",fettax.Total_Rate);
item_list.add(line_item_map);
}
pomap.put("tax_total",tx_val);
pomap.put("line_items",item_list);
post_url = zoho.books.createRecord("purchaseorders",org_id,pomap,conn_tok);
//info "Url:" + post_url;
res_code = post_url.get("code").toLong();
resp_Map = Map();
log_type = "Failure";
//info "rescode " + res_code;
varconn = API_Connections[Module_Name == "Zoho Books"].Connection;
if(res_code == 0)
{
log_type = "Success";
books_id = post_url.toMap().get("purchaseorder").toMap().get("purchaseorder_id");
fetchpo.Zoho_Books_ID=books_id;
test_map = Map();
mark_response = invokeurl
[
url :"https://www.zohoapis.in/books/v3/purchaseorders/" + books_id + "/status/open?organization_id=" + org_id + ""
type :POST
parameters:test_map
connection:"books_con"
];
//old api is commented and new api is in above as per Zoho
// mark_response = invokeurl
// [
// url :"https://www.zohoapis.in/books/v3/purchaseorders/" + books_id + "/status/open?organization_id=" + org_id + ""
// type :POST
// parameters:test_map
// connection:"books_con"
// ];
//info mark_response;
}
if(res_code == 0)
{
getinventory = zoho.inventory.getRecordsByID("purchaseorders",org_id,books_id);
get_line_item = getinventory.toMap().get("purchaseorder").toMap().get("line_items");
for each lineitem in get_line_item
{
lineitemid = lineitem.getjson("line_item_id");
itemid = lineitem.getjson("item_id");
itemorder = lineitem.getjson("item_order");
//array = {"custom_fields":{{"api_name":"cf_posubformid","value":cfposfid}}};
fetchpo = Purchase_Order[Zoho_Books_ID == books_id];
//fetchposf = Purchase_Order_Subform[Purchase_Order_ExisID == fetchpo.ID];
getmat = Materials[Zoho_Books_ID == itemid];
fetchposf = Purchase_Order_Subform[Purchase_Order_ExisID == fetchpo.ID && S_No == itemorder && Part_No == getmat.ID];
fetchposf.zb_line_item_id=lineitemid;
// for each posfrec in fetchposf
// {
// if(posfrec.Part_No == getmat.ID)
// {
// posfrec.zb_line_item_id=lineitemid;
// }
// }
}
}
//Insert into Log Form
ins_log = insert into Log_Files
[
Added_User=zoho.loginuser
Module_Name="Purchase Order"
Form_Name="Purchase Order"
Log_Details=post_url
Log_Type=log_type
Reference_NO=fetchpo.Purchase_Order_No
];
//sending error log message
if(log_type == "Failure")
{
resp_Map.put("Resp","Failure");
resp_Map.put("log_msg",post_url.get("message"));
}
//status to changed
// updtstatus = zoho.books.markStatus("purchaseorders",org_id,books_id,"Open",conn_tok);
// info updtstatus;
//When the log type is failure and rescode is code:57,message:You are not authorized to perform this operation" and try again call the function again after 5 minutes using the below function
if(res_code == 57 && log_type == "Failure")
{
insert into Failure_Functions_re_schedule_form
[
Added_User=zoho.loginuser
Module_name="Purchase Order"
module_record_id=var
Schedule_date_time=zoho.currenttime.addMinutes(5)
]
//send mail
sendmail
[
from :"erp@carrierwheels.com"
to :"parthasarathy.m@synprosoft.com"
subject :"Purchase Order Not pushed to Books" + var
message :"Purchase Order Not pushed to Books" + var
]
}
}
return resp_Map;
}
map Books.Get_Books_Access()
{
ret_mod_name = Company_Details[Sync_Process == "On"];
auth_tok = ret_mod_name.Connection;
org_id = ret_mod_name.Organisation_ID;
ret_map = Map();
ret_map.put("connection",auth_tok);
ret_map.put("organisation_id",org_id);
return ret_map;
}
void Books.Create_Packages(int disid)
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
fetchdisp = Create_Dispatch_Note_Format[ID == input.disid];
fetdispsf = Dispatch_Note_Subform[Create_Dispatch_Note_Plan_RECID == fetchdisp.ID];
fetch_cust = Customers[ID == fetchdisp.Customer_Name];
// if(fetch_cust.ID != 143536000004625764 && fetch_cust.ID != 143536000004570816 && fetch_cust.ID != 143536000005088666 && fetch_cust.ID != 143536000005117329)
// {
fetchso = Sales_Order[ID == fetchdisp.Sales_Order_ID];
soid = fetchso.Zoho_Books_ID;
ss = soid.tostring();
grnmap = Map();
// grnmap.put("package_number",fetchdisp.CDNF_ID);
grnmap.put("date",fetchdisp.Dispatch_Note_Date.toString("yyyy-MM-dd"));
grnmap.put("notes","Total Weight: " + fetchdisp.Total_Weight);
custom_list = List();
custom_map = Map();
custom_map.put("api_name","cf_dispatch_no");
custom_map.put("value",fetchdisp.CDNF_ID);
custom_list.add(custom_map);
grnmap.put("custom_fields",custom_list);
item_list = List();
actqtycheck = 0;
// info soid;
for each rec in fetdispsf
{
if(rec.Individual == false && rec.Actual_Qty > 0)
{
actqtycheck = 1;
fetchitem = Materials[ID == rec.Product_Code];
fet_so = Sales_Order[ID == fetchdisp.Sales_Order_No];
getsosf = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && Part_No == rec.Product_Code];
line_item_map = Map();
line_item_map.put("so_line_item_id",getsosf.zb_line_item_id);
if(rec.Actual_Qty > 0)
{
line_item_map.put("quantity",rec.Actual_Qty);
}
item_list.add(line_item_map);
}
}
info item_list + "Itemlist";
if(actqtycheck == 1)
{
//info item_list;
grnmap.put("line_items",item_list);
json = Map();
json.put("JSONString",grnmap);
info json;
crtrecord = invokeurl
[
url :"https://www.zohoapis.in/inventory/v3/packages?organization_id=" + org_id + "&salesorder_id=" + ss
type :POST
parameters:json
connection:"zoho_inventory"
];
info crtrecord;
rescode = crtrecord.get("code").toLong();
log_type = "Failure";
if(rescode == 0)
{
log_type = "Success";
var = crtrecord.get("package").get("package_id");
fetchdisp.Package_ID=var;
info rescode;
}
/* ins_log = insert into Log_Files
[
Added_User=zoho.loginuser
Module_Name="Packages-Books"
Form_Name="Dispatch_Note_Actual_In_Books-Packages"
Log_Details=crtrecord
Log_Type=log_type
Reference_NO=fetchdisp.CDNF_ID
]; */
}
}
void Books.Create_Cust_in_books(int cust)
{
//Getting authtoken and organisation id
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
//-------------------------------------------------------------------------
fet_cust = Customers[ID == input.cust];
cust_des = Destination[ID == fet_cust.Place_of_Supply];
cust_gst_trm = GST_Treatment[ID == fet_cust.GST_Treatment];
curr_code = Currency_Code[ID == fet_cust.Currency_Code];
web_cnvt = fet_cust.Web.toString();
web_suff = web_cnvt.getprefix("</a>");
web_final = web_suff.getsuffix(">");
custmap = Map();
custmap.put("contact_type","customer");
custmap.put("contact_name",fet_cust.Customer_Name);
custmap.put("company_name",fet_cust.Customer_Name);
//custmap.put("email",fet_cust.Email_ID);
custmap.put("mobile",fet_cust.Contact_Number);
custmap.put("phone",fet_cust.Phone_Number1);
custmap.put("pan_no",fet_cust.PAN_No);
custmap.put("gst_no",fet_cust.GST_No);
custmap.put("website",web_final);
custmap.put("place_of_contact",cust_des.Short_Name);
custmap.put("gst_treatment",cust_gst_trm.Link_name);
custmap.put("currency_id",curr_code.Zoho_Books_ID);
custmap.put("currency_code",curr_code.Currency_Code);
cont_list = List();
primary_cont_pers = Map();
primary_cont_pers.put("first_name",fet_cust.Customer_Name);
primary_cont_pers.put("phone",fet_cust.Contact_Number);
primary_cont_pers.put("email",fet_cust.Email_ID);
cont_list.add(primary_cont_pers);
//secndary Contact persons updated.
if(fet_cust.Contact_Person_Details != null)
{
for each contacts_val in fet_cust.Contact_Person_Details
{
cont_pers = Map();
cont_pers.put("first_name",contacts_val.Contact_Person_Name);
cont_pers.put("phone",contacts_val.Phone_Number);
cont_pers.put("email",contacts_val.Email);
cont_list.add(cont_pers);
}
}
custmap.put("contact_persons",cont_list);
bill_add = Map();
shipp_add = Map();
bill_add.put("address",fet_cust.Billing_Address.address_line_1);
bill_add.put("street2",fet_cust.Billing_Address.address_line_2);
bill_add.put("city",fet_cust.Billing_Address.district_city);
bill_add.put("state",fet_cust.Billing_Address.state_province);
bill_add.put("zip",fet_cust.Billing_Address.postal_Code);
bill_add.put("country",fet_cust.Billing_Address.country);
custmap.put("billing_address",bill_add);
shipp_add.put("address",fet_cust.Shipping_Address.address_line_1);
shipp_add.put("street2",fet_cust.Shipping_Address.address_line_2);
shipp_add.put("city",fet_cust.Shipping_Address.district_city);
shipp_add.put("state",fet_cust.Shipping_Address.state_province);
shipp_add.put("zip",fet_cust.Shipping_Address.postal_Code);
shipp_add.put("country",fet_cust.Shipping_Address.country);
custmap.put("shipping_address",shipp_add);
custmap.put("status","active");
custmap.put("cf_customer_code",fet_cust.Customer_Code);
//resp = zoho.books.createRecord("contacts",org_id,custmap,conn_tok);
resp = zoho.books.createRecord("contacts",org_id,custmap);
info resp;
res_code = resp.get("code").toLong();
if(res_code == 0)
{
books_id = resp.toMap().get("contact").toMap().get("contact_id");
fet_cust.Customer_Books_ID=books_id;
contact_person_list = List();
contact_person_list = resp.toMap().get("contact").toMap().get("contact_persons").toList();
for each contacts_1 in contact_person_list
{
contact_rec = contacts_1.toMap();
contact_Email = contact_rec.get("email");
contact_person_id = contact_rec.get("contact_person_id");
if(fet_cust.Email_ID == contact_Email)
{
fet_cust.contactPerson_Books_ID=contact_person_id;
}
else
{
updateContactPersonID = Contact_Person_Subform[Customer_Exis_ID == input.cust && Email == contact_Email];
if(updateContactPersonID.count() > 0)
{
updateContactPersonID.Contact_Person_Books_ID=contact_person_id;
}
}
}
}
//Insert into Log Details Report
// ins_log = insert into Log_Files
// [
// Added_User=zoho.loginuser
// Module_Name="Books"
// Form_Name="Customer"
// Log_Details=resp
// ];
}
void Invoice.Get_Invoice_from_Books(int recid)
{
try
{
getdata = Get_Invoice_ID_from_Books[ID == input.recid];
// info getdata;
zbinvoiceid = getdata.Invoice_Books_ID;
//info zbinvoiceid;
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
invoice_resp = zoho.books.getRecordsByID("invoices",org_id,zbinvoiceid,conn_tok);
// info "invresp" + invoice_resp;
invoice_data = invoice_resp.tomap().get("invoice");
saleno = "";
vehicleno = "";
trans = "";
for each rec1 in invoice_data.get("custom_fields")
{
if(rec1.get("label") == "Sales Order No")
{
saleno = rec1.get("value_formatted");
}
else if(rec1.get("label") == "Vehicle No")
{
vehicleno = rec1.get("value_formatted");
}
else if(rec1.get("label") == "Transporter")
{
trans = rec1.get("value_formatted");
}
}
// info "invdata" + invoice_data;
custname = invoice_data.get("customer_name");
invid = invoice_data.get("invoice_id");
custid = invoice_data.get("customer_id");
customer_id = Customers[Customer_Books_ID == custid].ID;
//info customer_id;
invdate = invoice_data.get("date").todate();
//info invdate;
invduedate = invoice_data.get("due_date").todate();
//info invduedate;
refno = ifnull(invoice_data.get("reference_number"),"");
// info refno;
custgst = ifnull(invoice_data.get("gst_no"),"");
//info custgst;
invno = invoice_data.get("invoice_number");
Payment_Terms = invoice_data.get("payment_terms_label");
payment_terms_id = Payment_Terms[Stages == Payment_Terms];
if(payment_terms_id.count(ID) == 0)
{
pmtterms_map = Map();
pmtterms_map.put("Stages",Payment_Terms);
dummy_map33 = Map();
zoho.creator.createRecord("carrierwheels","erp","Payment_Terms",pmtterms_map,dummy_map33,"vj_creator");
}
currency_code = invoice_data.get("currency_code");
currency_code_id = Currency_Code[Currency_Code == currency_code].ID;
//info currency_code;
Place_of_Supply = invoice_data.get("place_of_supply");
place_of_supply_id = Destination[Short_Name == Place_of_Supply].ID;
//info Place_of_Supply;
Source_of_Supply_id = Destination[Short_Name == "UP"].ID;
//info Source_of_Supply_id;
billingaddress = invoice_data.tomap().get("billing_address");
address_line_1 = billingaddress.get("address");
address_line_2 = billingaddress.get("street2");
district_city = billingaddress.get("city");
state_province = billingaddress.get("state");
postal_code = billingaddress.get("zip");
country = billingaddress.get("country");
fax_number = billingaddress.get("fax");
//info billingaddress;
shippingaddress = invoice_data.toMap().get("shipping_address");
address_line_11 = shippingaddress.get("address");
address_line_12 = shippingaddress.get("street2");
district_city1 = shippingaddress.get("city");
state_province1 = shippingaddress.get("state");
postal_code1 = shippingaddress.get("zip");
country1 = shippingaddress.get("country");
itemtotal = invoice_data.get("sub_total");
taxtotal = invoice_data.get("tax_total");
grandtotal = invoice_data.get("total");
gettcs = invoice_data.get("is_tcs_amount_in_percent");
if(gettcs == "true")
{
applytcs = gettcs;
tcs = invoice_data.get("tcs_tax_id");
tcs_id = Bill_TCS[Zoho_Books_ID == tcs].ID;
tcsvalue = invoice_data.get("tcs_amount");
}
//get the sales order details
getsomain = Sales_Order[Sale_Order_No == saleno];
info getsomain + "somain";
if(getsomain.count() > 0)
{
getsosub = Sale_Order_Subform[Sales_Order_Exis_ID == getsomain.ID];
cwstat = "Closed";
sostat = "Closed";
for each sosubfrm in Sale_Order_Subform[Sales_Order_Exis_ID == getsomain.ID]
{
if(sosubfrm.Balance_Qty > 0)
{
cwstat = "Closed Partially";
sostat = "Open";
}
}
getsomain.CWPL_SO_Status=cwstat;
getsomain.SO_Status=sostat;
if(getsomain.Sales_Type == "Contract" && getsomain.CWPL_SO_Status == "Shipped Completed")
{
getsomain.CWPL_SO_Status="Closed";
}
buyerordno = getsomain.PO_Reference;
buyrerorddt = getsomain.PO_Date;
dispatchnoteno = "";
if(getsomain.Dispatch_Note_No != null)
{
//dispatchnoteno = ifnull(getsomain.Dispatch_Note_No.CDNF_ID,"");
}
get_cfs = invoice_resp.get("invoice").toMap().get("custom_field_hash");
dispatchnoteno = get_cfs.get("cf_disp_note_no");
// info getsomain;
// info getsosub;
dnid = null;
getdnmain = Create_Dispatch_Note_Format[Sales_Order_No == getsomain.ID];
info getdnmain.count();
getdnmain.Draft_Invoice_No=invoice_data.get("invoice_number");
if(getdnmain.count() > 0)
{
dnid = getdnmain.ID;
VehicleNo = getdnmain.Vehicle_No;
DriverContactName = getdnmain.Driver_Name;
DriverContactNo = getdnmain.Driver_Mobile_Number;
NameofTransport1 = getdnmain.Transport_Name;
dispatchnoteno = getdnmain.ID;
dispatchnotedt = getdnmain.Dispatch_Note_Date;
grno = getdnmain.GR_No;
}
}
// sendmail
// [
// from :"erp@carrierwheels.com"
// to :"parthasarathy.m@synprosoft.com"
// subject :"getinvoicefrombooks function " + getdnmain.count() + "--" + getsomain.ID + " recid " + recid
// message :"getinvoicefrombooks function " + getdnmain.count() + "--" + getsomain.ID + " recid " + recid
// ]
str = thisapp.Common.Number_Function_New("Invoice");
//info str;
invoiceins = insert into Invoice
[
Customer_Name=customer_id
Invoice_No=invno
Invoice_Date=invdate
Invoice_Due_Date=invduedate
Reference_No=refno
Invoice_Status="open"
GST_No=custgst
Payment_Terms=payment_terms_id.ID
Currency_Code=currency_code_id
Place_of_Supply=place_of_supply_id
Source_of_Supply=Source_of_Supply_id
Billing_Address.address_line_1=address_line_1
Billing_Address.address_line_2=address_line_2
Billing_Address.district_city=district_city
Billing_Address.state_province=state_province
Billing_Address.postal_Code=postal_code
Billing_Address.country=country
Shipping_Address.address_line_1=address_line_11
Shipping_Address.address_line_2=address_line_12
Shipping_Address.district_city=district_city1
Shipping_Address.state_province=state_province1
Shipping_Address.postal_Code=postal_code1
Shipping_Address.country=country1
Vehicle_no1=vehicleno
Driver_Contact_Name=DriverContactName
Driver_Contact_No=DriverContactNo
Name_of_Transport=trans
Sale_Order_No=getsomain.ID
Sale_Order_Date=getsomain.Sale_Order_Date
Approval_Status="Approved"
Item_Total=itemtotal
Tax_Total=taxtotal
Grand_Total=grandtotal
Zoho_Books_ID=zbinvoiceid
Invoice_Type="Domestic Invoice"
Apply_TCS=applytcs
TCS=tcs_id
TCS_Value=tcsvalue
Create_Dispatch_Note_RECID=dnid
Buyer_Order_No=buyerordno
Buyer_Order_Date=buyrerorddt
Added_User=zoho.loginuser
Dispatch_Note_No=dispatchnoteno
Dispatch_Note_Date=dispatchnotedt
GR_No=grno
Sales_Type=getsomain.Sales_Type
];
if(getsomain.count() > 0)
{
solist = List();
solist.addAll(getsomain.Invoice_No);
solist.add(invoiceins);
getsomain.Invoice_No=solist;
info invoiceins;
info getsomain.Sale_Order_No;
info getsomain.Sale_Order_Date;
}
sno = 0;
lineitems = invoice_data.get("line_items");
taxperc = 0;
for each var in lineitems
{
taxvalue = 0;
taxperc = var.getjson("tax_percentage");
taxvalue = var.getjson("item_total") * taxperc / 100;
Totalamt = var.getjson("item_total") + taxvalue;
sno = sno + 1;
partno = Materials[Zoho_Books_ID == var.getjson("item_id")].ID;
custpartcode = Sale_Order_Subform[Sales_Order_Exis_ID == getsomain.ID && Part_No == partno].Customer_Part_Code;
invoicesub = insert into Invoice_Subform
[
S_No=sno
Part_No=Materials[Zoho_Books_ID == var.getjson("item_id")].ID
Part_Description=Materials[Zoho_Books_ID == var.getJSON("item_id")].ID
Dispatch_Plan_Date_time=getdnmain.Plan_Date_Time
Dispatch_Actual_Date_Time=getdnmain.Actual_Date_Time
Vehicle_Gate_in_Time=getdnmain.In_Time
Vehicle_Gate_out_time=getdnmain.Out_Time
HSN_Code=var.getjson("hsn_or_sac")
UoM=Unit_of_Measurement[UOM == var.getjson("unit")].ID
Qty=var.getjson("quantity")
Rate=var.getjson("rate")
Sub_Total=var.getjson("item_total")
Tax=GST_Details[Tax_Name == var.getjson("tax_name")].ID
Tax_Value=taxvalue
Total=Totalamt
Invoice_Exist_ID=invoiceins
Sales_Order_RECID=getsomain.ID
Added_User=zoho.loginuser
Customer_Part_Code=custpartcode
];
}
//Update the total Invoice Qty
totalinvqty = 0;
totalinvqty = Invoice_Subform[Invoice_Exist_ID == invoiceins].sum(Qty);
if(totalinvqty > 0)
{
getmaininv = Invoice[ID == invoiceins];
if(getmaininv.count() > 0)
{
getmaininv.Total_Invoice_Qty=ifnull(totalinvqty,"");
}
}
//Insert into Log Form
ins_log = insert into Log_Files
[
Added_User=zoho.loginuser
Module_Name="Invoice"
Form_Name="GetInvoicefromBooks"
Log_Details=invoice_resp
Log_Type="success"
Reference_NO=getsomain.Sale_Order_No
];
//update the E-Way Bill No.
invoice_resp = zoho.books.getRecordsByID("invoices",org_id,zbinvoiceid,conn_tok);
//info "invoice resp code " + invoice_resp.get("code") + "---" + zbid;
ewaybill = invoice_resp.get("invoice").toMap().get("eway_bill_details");
//info ewaybill;
sendmail
[
from :"erp@carrierwheels.com"
to :"parthasarathy.m@synprosoft.com"
subject :"Function Invoice.Getinvoicefrombooks ewaybill details " + zbinvoiceid
message :"ewaybill " + ewaybill
]
if(!isempty(ewaybill))
{
bno = ewaybill.get("eway_bill_number");
if(!isnull(bno))
{
getinv = Invoice[Zoho_Books_ID == zbinvoiceid];
if(getinv.count() > 0)
{
getinv.E_Way_Bill_No=ewaybill.get("eway_bill_number");
}
}
if(!isnull(ewaybill.get("eway_bill_date")))
{
getinv = Invoice[Zoho_Books_ID == zbinvoiceid];
if(getinv.count() > 0)
{
getinv.E_Way_Bill_Date=ewaybill.get("eway_bill_date").toString("dd-MMM-yyyy");
}
}
}
}
catch (e)
{
sendmail
[
from :"erp@carrierwheels.com"
to :"parthasarathy.m@synprosoft.com"
subject :"Invoice.Get Invoice from books try & catch" + zbinvoiceid
message :e
]
}
//update the Invoice number in Dispatch Note format
// if(getdnmain.count() > 0)
// {
// getdnmain.Invoice_Bill_No=str;
// }
//update the inventory , Check Inventory Forms
//lineitemsin = invoice_data.get("line_items");
// for each rec in lineitemsin
// {
// Part_No_id = Materials[Zoho_Books_ID == rec.getjson("item_id")].ID;
// Part_Description_id = Materials[Zoho_Books_ID == rec.getJSON("item_id")].ID;
// qty = rec.getjson("quantity");
// fetinvent = Inventory[Part_No == Part_No_id];
// //Subtracting available Stock
// if(fetinvent.count() > 0)
// {
// if(fetinvent.Total_Qty < fetinvent.Available_Qty)
// {
// fetinvent.Total_Qty=fetinvent.Available_Qty;
// }
// //blck_quantity = ifnull(fetinvent.Available_Qty,0.0) - ifnull(qty,0.0);
// tot_inv_qty = ifnull(fetinvent.Total_Qty,0.0) - ifnull(qty,0.0);
// //fetinvent.Block_Qty=fetinvent.Block_Qty - ifnull(qty,0.0);
// fetinvent.Total_Qty=tot_inv_qty;
// sendmail
// [
// from :zoho.loginuserid
// to :"parthasarathy.m@certifytechnologies.com"
// subject :"Invoice.Get_Invoice_from_Books"
// message :"Part no " + fetinvent.Part_No.Part_No + "Total Qty " + fetinvent.Total_Qty + "Availabel Qty " + fetinvent.Available_Qty
// ]
// }
//Subtract the quantity in check Inventory form
// fetchkinvent = Check_Inventory[Sales_Order_No == getsomain.ID && Part_No == Part_No_id && Customer_Name == customer_id];
// if(fetchkinvent.count() > 0)
// {
// if(fetchkinvent.Quantity_to_be_Blocked > 0)
// {
// fetchkinvent.Quantity_to_be_Blocked=fetchkinvent.Quantity_to_be_Blocked - ifnull(qty,0.0);
// if(fetchkinvent.Quantity_to_be_Blocked == 0)
// {
// fetchkinvent.Status="Closed";
// }
// }
// }
//getsosub.Invoiced_so_far_Qty=ifnull(getsosub.Invoiced_so_far_Qty,0.00) + ifnull(qty,0.0);
}
void Books.Create_invoice_individual(int dnaid)
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
disnote_act = Create_Dispatch_Note_Format[ID == input.dnaid];
fetch_cust = Customers[ID == disnote_act.Customer_Name];
fet_so = Sales_Order[ID == disnote_act.Sales_Order_No];
plc_of_supply = Destination[Destination == fet_so.Place_of_Supply.Destination].Short_Name;
for each rec in disnote_act.Product_Details
{
if(rec.Individual == true && rec.Actual_Qty > 0 && isNull(rec.Zoho_Books_Invoice_ID) == True)
{
disdate = disnote_act.Dispatch_Note_Date.toString("yyyy-MM-dd");
sodate = fet_so.Sale_Order_Date.toString("yyyy-MM-dd");
podate = fet_so.PO_Date.toString("yyyy-MM-dd");
mymap = Map();
info mymap;
mymap.put("customer_id",fetch_cust.Customer_Books_ID);
info fetch_cust.Customer_Books_ID;
mymap.put("customer_name",fetch_cust.Contact_Name);
info fetch_cust.Contact_Name;
mymap.put("billing_address_id",fetch_cust.Billing_Address_Id);
mymap.put("shipping_address_id",fetch_cust.Shipping_Address_id);
//mymap.put("billing_address",disnote_act.Customer_Address);
// info "custaddress" + disnote_act.Customer_Address;
// mymap.put("shipping_address",fet_so.Shipping_Address);
// info "Shipping" + fet_so.Shipping_Address;
mymap.put("place_of_supply",plc_of_supply);
// info "placeofsupply" + plc_of_supply;
custom_list = List();
custom_map = Map();
custom_map.put("api_name","cf_sales_order_no");
custom_map.put("value",fet_so.Sale_Order_No);
custom_list.add(custom_map);
// info "Salerderno" + fet_so.Sale_Order_No;
custom_map = Map();
custom_map.put("api_name","cf_dispatch_date");
custom_map.put("value",disdate);
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_disp_note_no");
custom_map.put("value",disnote_act.CDNF_ID);
custom_list.add(custom_map);
// info "dis date" + disnote_act.Dispatch_Note_Date;
custom_map = Map();
custom_map.put("api_name","cf_sales_order_date");
custom_map.put("value",sodate);
custom_list.add(custom_map);
info "sale date" + fet_so.Sale_Order_Date;
vehicle_no = "";
transpotor = "";
if(disnote_act.Transport_Type == "One Time")
{
vehicle_no = ifNull(disnote_act.Vehicle_No_dup,"");
transpotor = ifNull(disnote_act.Transporter_Name,"");
}
else
{
//vehicle_no = ifNull(disnote_act.Vehicle_No_dup,"");
vehicle_no = ifNull(disnote_act.Vehicle_No.Vehicle_No,"");
transpotor = ifNull(disnote_act.Transport_Name.Name_of_Transport,"");
}
custom_map = Map();
custom_map.put("api_name","cf_vehicle_no");
custom_map.put("value",vehicle_no);
custom_list.add(custom_map);
// info "vehicleno" + disnote_act.Vehicle_No;
custom_map = Map();
custom_map.put("api_name","cf_container_no");
custom_map.put("value",ifnull(disnote_act.Container_No,""));
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_transporter");
custom_map.put("value",transpotor);
custom_list.add(custom_map);
// info "transname" + disnote_act.Transporter_Name;
custom_map = Map();
custom_map.put("api_name","cf_gr");
custom_map.put("value",ifNull(disnote_act.GR_No,""));
custom_list.add(custom_map);
// info "grno" + disnote_act.GR_No;
custom_map = Map();
custom_map.put("api_name","cf_buyer_s_po_no");
custom_map.put("value",ifNull(fet_so.PO_Reference,""));
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_buyer_order_date");
custom_map.put("value",podate);
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_incoterms");
custom_map.put("value",ifNull(fet_so.Incoterms1.Incoterms,""));
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_incoterms_location");
custom_map.put("value",ifNull(fet_so.Incoterms_Location.Incoterms_Location,""));
custom_list.add(custom_map);
mymap.put("custom_fields",custom_list);
item_list = List();
fetchitem = Materials[ID == rec.Product_Code];
line_item_map = Map();
line_item_map.put("description",fetchitem.Classification);
// info "Product des" + rec.Product_Description;
line_item_map.put("item_id",fetchitem.Zoho_Books_ID);
line_item_map.put(" product_type","goods");
// info fetchitem.Zoho_Books_ID;
line_item_map.put("quantity",rec.Actual_Qty);
// info "ordee qty" + rec.Ordered_Qty;
fetsosub = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && Part_No == rec.Product_Code];
line_item_map.put("rate",fetsosub.Rate);
// info "rate" + rec1.Rate;
line_item_map.put("tax",fetsosub.Tax);
// info "Tax" + rec1.Tax;
line_item_map.put("tax_value",fetsosub.Tax_Value);
line_item_map.put("salesorder_item_id",fetsosub.zb_line_item_id);
line_sub = List();
custom_map = Map();
custom_map.put("label","Customer Part Code");
custom_map.put("value",ifNull(fetsosub.Customer_Part_Code,""));
line_sub.add(custom_map);
custom_map = Map();
custom_map.put("label","Packing");
custom_map.put("value",ifNull(fetsosub.Packing_Std.Packaging_Name,""));
line_sub.add(custom_map);
line_item_map.put("item_custom_fields",line_sub);
line_item_map.put("hsn_or_sac",fetsosub.HSN_Code);
// info "taxvalue" + rec1.Tax_Value;
custom_map = Map();
custom_map.put("label","UOM");
custom_map.put("value",ifnull(fetsosub.UoM.UOM,""));
line_sub.add(custom_map);
item_list.add(line_item_map);
mymap.put("line_items",item_list);
mymap.put("payment_terms_label",ifNull(fetch_cust.Payment_Terms.Stages,""));
mymap.put("payment_terms",fetch_cust.Exposure_Days);
info mymap;
createinbooks = zoho.books.createRecord("invoices","60015333461",mymap,conn_tok);
info createinbooks;
retainerno = createinbooks.get("invoice").toMap();
retinvno = retainerno.get("invoice_number");
retinvid = retainerno.get("invoice_id");
rec.Zoho_Books_Invoice_ID=retinvid.toString();
rescode = createinbooks.get("code").toLong();
log_type = "Failure";
if(rescode == 0)
{
log_type = "Success";
}
ins_log = insert into Log_Files
[
Added_User=zoho.loginuser
Module_Name="Invoice-Books"
Form_Name="Dispatch_Note_Actual_In_Books-Invoice Individual"
Log_Details=createinbooks
Log_Type=log_type
Reference_NO=disnote_act.CDNF_ID
];
//disnote_act.Draft_Invoice_ID=retinvid.toString();
// info disnote_act.Draft_Invoice_ID;
//disnote_act.Draft_Invoice_No=retinvno;
//info disnote_act.Draft_Invoice_No;
//fet_so.Books_Invoice_ID=retinvid.toString();
}
}
}
void Books.Dispatch_Note_Actual_In_Books(int dnaid)
{
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
disnote_act = Create_Dispatch_Note_Format[ID == input.dnaid];
fetch_cust = Customers[ID == disnote_act.Customer_Name];
if(fetch_cust.ID != 143536000004625764 && fetch_cust.ID != 143536000004570816 && fetch_cust.ID != 143536000005088666 && fetch_cust.ID != 143536000005117329)
{
fet_so = Sales_Order[ID == disnote_act.Sales_Order_No];
fettax = GST_Details[ID == fet_so.Item_Details.Tax];
// info fet_so;
plc_of_supply = Destination[Destination == fet_so.Place_of_Supply.Destination].Short_Name;
disdate = disnote_act.Dispatch_Note_Date.toString("yyyy-MM-dd");
sodate = fet_so.Sale_Order_Date.toString("yyyy-MM-dd");
podate = fet_so.PO_Date.toString("yyyy-MM-dd");
info disdate;
info sodate;
mymap = Map();
//info mymap;
mymap.put("customer_id",fetch_cust.Customer_Books_ID);
// info fetch_cust.Customer_Books_ID;
mymap.put("customer_name",fetch_cust.Contact_Name);
//info fetch_cust.Contact_Name;
mymap.put("billing_address_id",fetch_cust.Billing_Address_Id);
//info "custaddress" + fetch_cust.Billing_Address_Id;
//mymap.put("shipping_address_id",fetch_cust.Shipping_Address_id);
mymap.put("shipping_address",disnote_act.Customer_Address);
//info "Shipping" + fet_so.Shipping_Address;
mymap.put("place_of_supply",plc_of_supply);
// info "placeofsupply" + plc_of_supply;
custom_list = List();
custom_map = Map();
custom_map.put("api_name","cf_sales_order_no");
custom_map.put("value",fet_so.Sale_Order_No);
custom_list.add(custom_map);
// info "Salerderno" + fet_so.Sale_Order_No;
custom_map = Map();
custom_map.put("api_name","cf_dispatch_date");
custom_map.put("value",disdate);
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_disp_note_no");
custom_map.put("value",disnote_act.CDNF_ID);
custom_list.add(custom_map);
// info "dis date" + disnote_act.Dispatch_Note_Date;
custom_map = Map();
custom_map.put("api_name","cf_sales_order_date");
custom_map.put("value",sodate);
custom_list.add(custom_map);
//info "sale date" + fet_so.Sale_Order_Date;
vehicle_no = "";
transpotor = "";
if(disnote_act.Transport_Type == "One Time")
{
vehicle_no = ifNull(disnote_act.Vehicle_No_dup,"");
transpotor = ifNull(disnote_act.Transporter_Name,"");
}
else
{
//vehicle_no = ifNull(disnote_act.Vehicle_No_dup,"");
vehicle_no = ifNull(disnote_act.Vehicle_No.Vehicle_No,"");
transpotor = ifNull(disnote_act.Transport_Name.Name_of_Transport,"");
}
custom_map = Map();
custom_map.put("api_name","cf_vehicle_no");
custom_map.put("value",vehicle_no);
custom_list.add(custom_map);
// info "vehicleno" + disnote_act.Vehicle_No;
custom_map = Map();
custom_map.put("api_name","cf_container_no");
custom_map.put("value",ifnull(disnote_act.Container_No,""));
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_transporter");
custom_map.put("value",transpotor);
custom_list.add(custom_map);
// info "transname" + disnote_act.Transporter_Name;
custom_map = Map();
custom_map.put("api_name","cf_gr");
custom_map.put("value",ifNull(disnote_act.GR_No,""));
custom_list.add(custom_map);
// info "grno" + disnote_act.GR_No;
custom_map = Map();
custom_map.put("api_name","cf_buyer_s_po_no");
custom_map.put("value",ifNull(fet_so.PO_Reference,""));
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_buyer_order_date");
custom_map.put("value",podate);
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_incoterms");
custom_map.put("value",ifNull(fet_so.Incoterms1.Incoterms,""));
custom_list.add(custom_map);
custom_map = Map();
custom_map.put("api_name","cf_incoterms_location");
custom_map.put("value",ifNull(fet_so.Incoterms_Location.Incoterms_Location,""));
custom_list.add(custom_map);
mymap.put("custom_fields",custom_list);
item_list = List();
actqtycheck = 0;
tx_val = 0;
for each rec in disnote_act.Product_Details
{
if(rec.Individual == false && rec.Actual_Qty > 0 && isNull(disnote_act.Draft_Invoice_ID) == True)
{
actqtycheck = 1;
fetchitem = Materials[ID == rec.Product_Code];
line_item_map = Map();
line_item_map.put("description",fetchitem.Classification);
// info "Product des" + rec.Product_Description;
line_item_map.put("item_id",fetchitem.Zoho_Books_ID);
line_item_map.put(" product_type","goods");
// info fetchitem.Zoho_Books_ID;
line_item_map.put("quantity",rec.Actual_Qty);
// info "ordee qty" + rec.Ordered_Qty;
fetsosub = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && Part_No == rec.Product_Code];
//info fetsosub;
line_item_map.put("rate",fetsosub.Rate);
// info "rate" + rec1.Rate;
//line_item_map.put("tax",fetsosub.Tax);
// info "Tax" + rec1.Tax;
//line_item_map.put("tax_value",fetsosub.Tax_Value);
line_item_map.put("tax_id",fetsosub.Tax.Zoho_Books_ID);
line_item_map.put("salesorder_item_id",fetsosub.zb_line_item_id);
line_sub = List();
custom_map = Map();
custom_map.put("label","Customer Part Code");
custom_map.put("value",ifNull(fetsosub.Customer_Part_Code,""));
line_sub.add(custom_map);
custom_map = Map();
custom_map.put("label","Packing");
custom_map.put("value",ifNull(fetsosub.Packing_Std.Packaging_Name,""));
line_sub.add(custom_map);
line_item_map.put("item_custom_fields",line_sub);
line_item_map.put("hsn_or_sac",fetsosub.HSN_Code);
custom_map = Map();
custom_map.put("label","UOM");
custom_map.put("value",ifnull(fetsosub.UoM.UOM,""));
line_sub.add(custom_map);
item_list.add(line_item_map);
}
}
if(fet_so.Packing_Forwarding > 0)
{
fetchitem = Materials[Part_No == "900114"];
line_item_map = Map();
line_item_map.put("name",fetchitem.Part_Description);
line_item_map.put("item_id",fetchitem.Zoho_Books_ID);
//line_item_map.put("quantity",1);
line_item_map.put("rate",fet_so.Packing_Forwarding);
line_item_map.put("tax_name",fettax.Tax_Name);
line_item_map.put("tax_id",fettax.Zoho_Books_ID);
line_item_map.put("tax_percentage",fettax.Total_Rate);
item_list.add(line_item_map);
tx_val = ifnull(tx_val,0.0) + ifnull(fet_so.PF_Tax_value,0.0);
}
mymap.put("tax_total",tx_val);
if(actqtycheck == 1)
{
mymap.put("line_items",item_list);
mymap.put("payment_terms_label",ifNull(fetch_cust.Payment_Terms.Stages,""));
mymap.put("payment_terms",fetch_cust.Exposure_Days);
info mymap;
createinbooks = zoho.books.createRecord("invoices","60015333461",mymap,conn_tok);
info createinbooks;
rescode = createinbooks.get("code").toLong();
log_type = "Failure";
if(rescode == 0)
{
log_type = "Success";
}
ins_log = insert into Log_Files
[
Added_User=zoho.loginuser
Module_Name="Invoice-Books"
Form_Name="Dispatch_Note_Actual_In_Books-Invoice"
Log_Details=createinbooks
Log_Type=log_type
Reference_NO=disnote_act.CDNF_ID
];
retainerno = createinbooks.get("invoice").toMap();
retinvno = retainerno.get("invoice_number");
retinvid = retainerno.get("invoice_id");
retain_upd_map = Map();
retain_dummyMap = Map();
// retain_upd_map.put("Invoice_No",retinvno);
retain_upd_map.put("invoice_ID",retinvid);
disnote_act.Draft_Invoice_ID=retinvid.toString();
//disnote_act.Draft_Invoice_No=retinvno;
fet_so.Books_Invoice_ID=retinvid.toString();
}
}
}
void Books.Create_Sales_Order_in_Books(int soid)
{
//Getting authtoken and organisation id
books_access = thisapp.Books.Get_Books_Access();
conn_tok = books_access.get("connection");
org_id = books_access.get("organisation_id");
//info auth_tok;
//info org_id;
//------------------------------------------------------------------------------
fetch_so = Sales_Order[ID == input.soid];
//info fetch_so;
fetch_cust = Customers[ID == fetch_so.Customer_Name];
//info ("fetchcust" + fetch_cust) + " " + fetch_cust.Customer_Books_ID;
fetch_delivery_method = Shipping_Mode[ID == fetch_so.Delivery_Mode].Shipping_Mode;
fetch_warehouse = Warehouse[ID = fetch_so.Warehouse].Warehouse_Name;
fettax = GST_Details[ID == fetch_so.Item_Details.Tax];
fetemp = Employee_Details[ID == fetch_so.Created_By].Employee_Name;
fetch_payment_trms = Payment_Terms[ID == fetch_so.Payment_Terms].Stages;
shipment_date = fetch_so.Expected_Shipment_Date.toString("yyyy-MM-dd");
so_date = zoho.currentdate.toString("yyyy-MM-dd");
curr_code = Currency_Code[ID == fetch_cust.Currency_Code];
curr_conv = Currency_Conversion[Convert_To == fetch_cust.Currency_Code];
plc_of_supply = Destination[Destination == fetch_so.Place_of_Supply.Destination].Short_Name;
fet_gst_trmt = GST_Treatment[ID == fetch_cust.GST_Treatment];
mymap = Map();
mymap.put("customer_id",fetch_cust.Customer_Books_ID);
mymap.put("customer_name",fetch_cust.Contact_Name);
mymap.put("date",so_date);
//mymap.put("billing_address",fetch_so.Billing_Address);
//mymap.put("shipping_address",fetch_so.Shipping_Address);
mymap.put("shipment_date",shipment_date);
mymap.put("delivery_method",fetch_delivery_method);
mymap.put("place_of_supply",plc_of_supply);
mymap.put("gst_treatment",fet_gst_trmt.Link_name);
mymap.put("salesorder_number",fetch_so.Sale_Order_No);
mymap.put("salesperson_name",fetemp);
mymap.put("currency_id",curr_code.Zoho_Books_ID);
mymap.put("exchange_rate",curr_conv.Exchange_Rate);
mymap.put("status","Open");
url_to_so = "https://creatorapp.zoho.in/carrierwheels/erp/#Page:SO_Print?ID=" + soid;
custom_list = List();
custom_map = Map();
custom_map.put("api_name","cf_download_so_from_erp");
custom_map.put("value",url_to_so);
custom_list.add(custom_map);
mymap.put("custom_fields",custom_list);
item_list = List();
tx_val = 0;
totalqty = 0;
for each rec in fetch_so.Item_Details
{
fetchitem = Materials[ID == rec.Part_Description];
line_item_map = Map();
line_item_map.put("name",rec.Part_Description.Part_Description);
line_item_map.put("item_id",fetchitem.Zoho_Books_ID);
// line_item_map.put("description",rec.Part_Description.Additional_Description);
line_item_map.put("quantity",rec.Qty);
totalqty = ifnull(totalqty,0.00) + ifnull(rec.Qty,0.00);
line_item_map.put("rate",rec.Rate);
line_item_map.put("warehouse_name",fetch_warehouse);
//line_item_map.put("tax_type",fettax.Tax_Details.Tax_Type);
line_item_map.put("tax_name",fettax.Tax_Name);
line_item_map.put("tax_id",fettax.Zoho_Books_ID);
line_item_map.put("tax_percentage",fettax.Total_Rate);
item_list.add(line_item_map);
tx_val = ifnull(tx_val,0.0) + ifnull(rec.Tax_Value,0.0);
}
if(fetch_so.Packing_Forwarding > 0)
{
fetchitem = Materials[Part_No == "900114"];
line_item_map = Map();
line_item_map.put("name",fetchitem.Part_Description);
line_item_map.put("item_id",fetchitem.Zoho_Books_ID);
//line_item_map.put("quantity",1);
line_item_map.put("rate",fetch_so.Packing_Forwarding);
line_item_map.put("warehouse_name",fetch_warehouse);
line_item_map.put("tax_name",fettax.Tax_Name);
line_item_map.put("tax_id",fettax.Zoho_Books_ID);
line_item_map.put("tax_percentage",fettax.Total_Rate);
item_list.add(line_item_map);
tx_val = ifnull(tx_val,0.0) + ifnull(fetch_so.PF_Tax_value,0.0);
}
mymap.put("tax_total",tx_val);
mymap.put("line_items",item_list);
post_url = zoho.books.createRecord("salesorders",org_id,mymap,conn_tok);
info post_url;
res_code = post_url.get("code").toLong();
resp_Map = Map();
log_type = "Failure";
if(res_code == 0)
{
log_type = "Success";
books_id = post_url.toMap().get("salesorder").toMap().get("salesorder_id");
fetch_so.Zoho_Books_ID=books_id;
test_map = Map();
mark_response = invokeurl
[
url :"https://www.zohoapis.in/books/v3/salesorders/" + books_id + "/status/open?organization_id=" + org_id + ""
type :POST
parameters:test_map
connection:"books_con"
];
}
if(res_code == 0)
{
getzbook = zoho.books.getRecordsByID("salesorders",org_id,books_id);
get_line_item = getzbook.toMap().get("salesorder").toMap().get("line_items");
for each lineitem in get_line_item
{
lineitemid = lineitem.getjson("line_item_id");
itemid = lineitem.getjson("item_id");
fetso = Sales_Order[Zoho_Books_ID == books_id];
fetsosf = Sale_Order_Subform[Sales_Order_Exis_ID == fetso.ID];
getmat = Materials[Zoho_Books_ID == itemid];
for each sosfrec in fetsosf
{
if(sosfrec.Part_No == getmat.ID)
{
sosfrec.zb_line_item_id=lineitemid;
fetso.pack_forw_lineitemid=lineitemid;
}
}
}
}
ins_log = insert into Log_Files
[
Added_User=zoho.loginuser
Log_Type=log_type
Module_Name="Books"
Form_Name="Sales Order"
Log_Details=post_url
Reference_NO=fetch_so.Sale_Order_No
];
//sending error log message
if(log_type == "Failure")
{
resp_Map.put("Resp","Failure");
resp_Map.put("log_msg",post_url.get("message"));
}
//status to changed
updtstatus = zoho.books.markStatus("salesorders",org_id,books_id,"open",conn_tok);
}
for each rec in Calibration_Master[ID != null && Cal_Due_Date != null]
{
if(rec.Today != zoho.currentdate)
{
rec.Today=zoho.currentdate;
//info rec.Today;
info rec.Cal_Due_Date;
daysleft = daysBetween(rec.Today,rec.Cal_Due_Date);
rec.Days_Left=daysleft;
info daysleft;
if(rec.Days_Left.toNumber() <= 30 && rec.Days_Left.toNumber() > 0)
{
rec.Status1="Attention";
}
else if(rec.Days_Left.toNumber() > 30)
{
rec.Status1="No Issue";
}
else if(rec.Days_Left.toNumber() <= 0)
{
rec.Status1="Urgent";
}
}
}
star
photo_camera
Wed Jan 08 2025 01:53:40 GMT+0000 (Coordinated Universal Time) https://thinkingclaude.com/#get-started
Save snippets that work with our extensions
